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 “sorghos” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
sorghos1132760(None) 
sorgho10348711sorgho_
sorgos74514661sorg_os
morphos14159082morphos
sargos74318272sarg_os
sorghum1343512sorghum
sorghums1442632sorghums
sorgo64719722sorg_o_
soughs105115622sough_s
bohos105618253bo__hos
bongos95316653bong_os
borshts1266543borshts
boughs125414373bough_s
burghs12519923burgh_s
burgoos1037123burgoos
cargos94619183carg_os
cohos105921853co__hos
conchos144313963conchos
congos94219883cong_os
corgis9314413corg_is
coughs125514543cough_s
dorados938203dorados
doughs115912933dough_s
forgers115218183forgers
forges105024263forg_es
forgets113813793forgets
forgo94418333forg_o_
forgoes11311353forgoes
forgot104318133forg_ot
gogos77516523go_g_os
gorgeous1046293gorgeous
gorgers94813643gorgers
gorges85321893gorg_es
gorgets94711783gorgets
gorgon8310243gorg_on
gorgons938853gorgons
honchos15369573honchos
horahs126313873horah_s
kolkhos1364013kolkhos
largos74815063larg_os
logos67225333lo_g_os
lorgnon844423lorgnon
lorgnons943993lorgnons
loughs105014773lough_s
mongos94318623mong_os
morgans10310123morgans
morgens10310463morgens
morgues1038273morgues
morpho13158443morpho_
morphs13149433morph_s
morros83714673mor_ros
norths96812323north_s
noughts11478083noughts
orchis11710773_orchis
ordos65216203_or_dos
organs7912913_organs
orgies72316093_orgies
ortho8312293_ortho_
orzos143311253_or_zos
oughts104710183_oughts
pargos95719043parg_os
ponchos143410703ponchos
porches143815673porches
porgies103017003porgies
pornos85015253por_nos
pothos114214693po_thos
rhos76319063__r_hos
roughs105416213rough_s
sagos66123873s_ag_os
sanghs105312063sangh_s
sarges75128593sarg_es
sargo65424413sarg_o_
saros55238063sar__os
saughs104812053saugh_s
scorches15189143scorches
segnos73610443s_egnos
segos64919483s_eg_os
sergers83815633sergers
serges74225973serg_es
servos93812723ser_vos
sighs95416743s_igh_s
sights103818013s_ights
siglos7311473s_iglos
skyphos1963733skyphos
slights112810723slights
sloughs11497563slough_s
solanos74412853solanos
solos54830793so__los
somehow1543663somehow
songs67725553song__s
soothes103917113soothes
sooths95715593sooth_s
sophs104916023so_ph_s
sopranos1046433sopranos
soras55041013sor__as
sorbets93012513sorbets
sorbose938983sor_bose
sorbs75022103sor__bs
sordor7310223sor_dor
sordors8310013sordors
sords64527803sor__ds
sorels63921163sor_els
sores55454283sor__es
sorings83817253sorings
sorites73825243sorites
sorners73416873sorners
sorns55028423sor__ns
soroches1338803soroches
soroses73117483soroses
sorosis72611973sorosis
sorrels7310723sorrels
sorrow9339443sor_row
sorrows10278403sorrows
sorters74221133sorters
sorties74126403sorties
sorts54536663sor__ts
sorus54527583sor__us
soths86218633so_th_s
sough95320463sough__
soughed123811623soughed
sought106315053sough_t
souths95216603south_s
sovkhoz2642093sovkhoz
sprights14167143sprights
sughs95313323s_ugh_s
surahs94515543surah_s
surgeon837003surgeon
surgeons947033surgeons
surgers83517483surgers
surges73924593surg_es
torahs95115643torah_s
torches123715433torches
torchon1237363torchon
torchons1337503torchons
toreros7311343toreros
toros54336193tor__os
torsos64815733tor_sos
toughs105414983tough_s
worths127812893worth_s
yoghs125410593yo_gh_s

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271405.95322514.2
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.38927968.5
 
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.