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

141 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
uropods103587(None) 
uropod937261uropod_
broods95416382bro_ods
isopods1045572isopods
roods65125282_ro_ods
sauropods1293672sauropods
tripods10359052tripods
unipods1095702unipods
uropodal1144162uropodal
uropodous1253622uropodous
apods86316343__apods
apropos1138843apropo_s
aroids75118223aro_ids
bipods11408593_bipods
bloods94614843blo_ods
broads94515153bro_ads
bromids12278603bromids
bromos104213313bromo_s
brood84620243bro_od_
broody124510083bro_ody
brooks125813883bro_oks
brooms104915873bro_oms
broos75126413bro_o_s
crepons1139313crepons
crooks124914413cro_oks
croons85418423cro_ons
crops96125233crop__s
crotons93714373crotons
croupous1245923croupous
crowds124910763cro_wds
droids84712583dro_ids
dromonds1244613dromonds
dromons1038193dromons
drools74412813dro_ols
droops95110963dro_ops
dropout10410003dropout
dropouts1145003dropouts
drops85719503drop__s
drownds12346153drownds
endopods1245673endopods
eurokous1243673eurokous
floods104511653flo_ods
foods95924163_fo_ods
fronds106412343fro_nds
goods75124483_go_ods
grooms94512523gro_oms
groped107515053groped_
gropers104813853gropers
gropes95220403grop_es
grounds9228313grounds
groupoids1342463groupoids
hoods95124083_ho_ods
hoopoes121212483hoopoes
hoopoos1298543hoopoos
irokos1037233iroko_s
isopod935913isopod_
kroons103711243kro_ons
lycopods1643733lycopods
monopods1347973monopods
moods85224623_mo_ods
mopeds11499663_mopeds
myriopods1751823myriopods
octopods1344343octopods
pereopods1444233pereopods
pleopods1344443pleopods
pods76540153___pods
poods85124753_po_ods
prods85523553pr__ods
prologs103512133prologs
promos105116423promo_s
proofs114511683pro_ofs
propels113412843propels
propends13249173propends
propers113619033propers
propolis12311403propolis
propone112716303propone
propones122516963propones
propose112714843propose
proposes122515973proposes
propounds1444963propounds
props95726883prop__s
propyls14308193propyls
prosody1336433prosody
prosos85718553proso_s
protons93118003protons
protopods1446993protopods
pteropods1444653pteropods
rapids94913893_rapids
repos74725793_repo_s
repots85621003_repots
resods74116303_resods
roads66523623_ro_ads
robots8313153_robots
rods56442063_r__ods
rondos74616733_rondos
rood56733003_ro_od_
roofs85321153_ro_ofs
rooks95325043_ro_oks
rooms75324683_ro_oms
roots55933673_ro_ots
roped84630803_roped_
ropers84325903_ropers
ropes75940063_rop_es
rotors64917953_rotors
rotos56027883_roto_s
rounds73615623_rounds
sauropod11103773sauropod_
snoods74312453sno_ods
sopors85215203_sopors
theropods1544953theropods
topos75726393_topo_s
torpids1037373torpids
torpors939383torpors
tripod9399853tripod_
tripody13395983tripody
tripos84014923tripo_s
trogons83410723trogons
troops85712783tro_ops
tropes84824353trop_es
tropics113610653tropics
tropins93116303tropins
unhoods1137503unhoods
unipod946853unipod_
unroofs1035783unro_ofs
unroots738563unro_ots
unroped102812103unroped_
unrounds9145573unrounds
updos8389513u__pdos
uproots937143upro_ots
uranous7310733uranous
urds55922423ur___ds
uredos73910623uredo_s
urinous7310083urinous
urochords1544213urochords
urology11217583urology
urped84615283ur_ped_
urps66920473ur_p__s
ursids737823ur_sids
utopias9117723utopias
vrooms11398713vro_oms
woods95723033_wo_ods

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.1561145455.1
2DLD Change Limit1340271416.93619323.4
3Display Results1411410.0502820.0
 (SQL Overall)1786911417.14225019.7
 
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.