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 “eryngos” 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.

72 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
eryngos114273(None) 
eringos836911eringos
eryngo1033611eryngo_
eryngoes1242941eryngoes
drongos935492drongos
eringo739552eringo_
eringoes937432eringoes
erugos7347342er_ugos
gringos936672gringos
aerugos834923aer_ugos
azygos1933323azy_gos
bingos95514793_bingos
bongos95316653_bongos
brings94618433bring_s
broncos11188073broncos
congos94219883_congos
cringes103215503cringes
cryptos14337213cryptos
deranges1039973deranges
drongo836793drongo_
dryness11114783dryness
earings84517703earing_s
eggnogs1041923eggnogs
egos55821653e___gos
engs56121393e__ng_s
epinaos936283epinaos
erenow937373eren_ow
ergo56420153er__go_
ergot65422893er__got
ergots74512373er__gots
ergs55523813er__g_s
ernes55224813er_n_es
erns45428223er_n__s
eros45238453er___os
erugo6369853er_ugo_
ethnos947053ethn_os
fringes113514103fringes
fynbos1433283_fynbos
granges93516523granges
gregos847533gr_egos
gringas938033gringas
gringo838643gringo_
grunges93310403grunges
larynges1244503larynges
mangos94319333_mangos
merinos9311973merin_os
mongos94318623_mongos
mungos94311373_mungos
olingos846013olingos
oranges84215333oranges
orangs74116033orang_s
pengos94612413_pengos
pingos95317673_pingos
prangs94816233prang_s
prongs94314483prong_s
quangos1734653quangos
ranges73826923_ranges
rings65029173_ring_s
rondos74616723_rondos
rungs611819403_rung_s
rynds9569973_ryn_ds
seringas9339003seringas
serpigos1143843serpigos
stingos8459443stingos
syngas10368913_syngas
tangos74216303_tangos
trigos74214173tr_igos
vertigos1254973vertigos
wrangs104611913wrang_s
wrings104012973wring_s
wrongs10338933wrong_s
wryness13113983wryness

Search took 8 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 Filter1786911340270.190940478.9
2DLD Change Limit134027727.57617691.0
3Display Results72720.0332181.8
 (SQL Overall)178691727.79922912.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.