Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “epizoa” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
epizoa174501(None) 
epigon937962epigon
epilog976462epilog
epizoic2045192epizoic
epizoon1843812epizoon
pizza1538182_pizza
baiza164813223baiz_a
ectozoa1843143ectozoa
editor738663editor
eidola737683e_idola
eidos65817753e_idos
eikon939463e_ikon
enigma935643enigma
entozoa1644233entozoa
epazote1843703epazote
epha9310053ep__ha
ephod1139123ep_hod
ephor10310013ep_hor
epiboly1454353epiboly
epic86921303epi__c
epical10413393epical
epics95014283epi_cs
epidote1037393epidote
epifocal1543793epifocal
epigeal1046243epigeal
epigean1045503epigean
epigone1057843epigone
epigoni1056093epigoni
epigons1048183epigons
epigram1247473epigram
epilogs1076583epilogs
epimer10109153epimer
epinaoi945013epinaoi
epinaos936283epinaos
episcia1145123episcia
episode1056303episode
episomal1245553episomal
episome1157813episome
epitome1157743epitome
epitope1147053epitope
epizoism2163513epizoism
epizoite1944143epizoite
epizooty2242143epizooty
epos66723733ep__os
epsilon944293epsilon
erica7316543eri_ca
feijoa1642223feijoa
metazoa1845543metazoa
pepino10310333pepino_
pepinos1137693pepinos
pia56848033_pi__a
piazza1643823_piazza
pica85831493_pi_ca
picot95031013_picot
pieta75421753_pieta
pika106322953_pi_ka
pilea75123953_pilea
pilot77435063_pilot
pima85428653_pi_ma
pina65842633_pi_na
pinna75320183_pinna
pinon76024533_pinon
pinot78737293_pinot
pinta75727053_pinta
pion67235293_pi_on
pirog83913673_pirog
piso66727563_piso_
pisos76021063_pisos
pita65436433_pi_ta
piton76121583_piton
pitta75018693_pitta
pivot106523873_pivot
pizzas1646983_pizzas
pizzaz1565443_pizzaz
proa66229963_p_roa
quinoa15377653quinoa
rhizoma2143283rhizoma
seizor15428523seizor
sepia75318673sepi__a
spica94717943spi_ca
spigot9312603spigot
spinor839943spinor
spirea84015633spirea
vizor173010093_vizor
zoa128529993___zoa

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1261418182.5
2DLD Change Limit112716856.75016698.7
3Display Results85850.0302833.3
 (SQL Overall)178691856.90625874.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.