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

137 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
crowdie133590(None) 
crowdies1437541crowdies
brownie12178432brownie
cowpie133511512c_owpie
cowrie113814272c_owrie
croppie13278792croppie
crowd115815622crowd__
crowded14418782crowded
crowder13389842crowder
crowding15247932crowding
crowds124910762crowd_s
crowdy15467172crowd_y
howdie13349722_howdie
roadie72813802_roadie
rowdier11348592_rowdier
rowdies113112692_rowdies
brawlie12198153brawlie
bromide12269583bromide
broodier1157433broodier
brookie1347373brookie
brownier13226913brownier
brownies13189613brownies
browse115713853brow_se
caddie104316443c_addie
chowder16387803chowder
chowse144711753chow_se
chowtime1842943chowtime
chromide1648053chromide
cloddier1234063cloddier
cloudier1135053cloudier
clowder13367933clowder
coddle104713853c_oddle
code77347733c_o_d_e
coedit9316233c_oedit
collie83621993c_ollie
commie124215523c_ommie
cookie123716043c_ookie
coolie83821603c_oolie
coontie9311413coontie
cootie84223073c_ootie
corbie103618203c_orbie
cordite10315253c_ordite
corodies11313693corodies
corrie83621213c_orrie
cosie74728263c_o_sie
coude85022633c_oud_e
cowage12310663c_owage
cowhide1636133c_owhide
cowier113616163c_ow_ier
cowpies143314283c_owpies
cowries124218013c_owries
cowrite123612683c_owrite
cozie163519123c_o_zie
cradle93313163cr_adle
crappie13298983crappie
crawdad1443113crawdad
crawlier13216873crawlier
credit9315193cr_edit
creepie1137483creepie
croakier14436263croakier
crocein1138073crocein
croceine1248033croceine
croci95818133cro_ci_
crocine11314153crocine
crocodile1443803crocodile
crocoite1248053crocoite
crojik1934113cro_jik
crone75231333cro__ne
cronies9622503cro_nies
croppies143111133croppies
croquis1834763croquis
crore74922863cro__re
crosier94116573cro_sier
crosse85216303cro_sse
crosstie1046933crosstie
croupe105114433cro_upe
croupier1246883croupier
crouse84619363cro_use
croute84617273cro_ute
crow96428133crow___
crowbar1444253crowbar
crowders14398793crowders
crowed124717293crow_ed
crower114117553crow_er
crowers124614893crowers
crowfeet1645553crowfeet
crowing133814763crowing
crown105620083crow__n
crowned133912423crowned
crowner124012593crowner
crownet123714113crownet
crowning143510033crowning
crowns115615113crow_ns
crows105727313crow__s
crowstep1543333crowstep
croze164719453cro__ze
crozier18369933cro_zier
cruddier1244153cruddier
crude86018573cr_ud_e
crummie1336153crummie
cuddie104011173c_uddie
dowdier12328573_dowdier
dowdies123412733_dowdies
dowie94721143_dow_ie
drowse105010553drow_se
drowsier1284903drowsier
erode64520993ero_d_e
foodie104413843_foodie
frowsier1444893frowsier
frowzier2343313frowzier
goodie83613993_goodie
grodier939673gro_dier
groupie1045783groupie
growlier1234883growlier
hoodie105116133_hoodie
howdied15296843_howdied
howdies142911953_howdies
oldie6415473__oldie
oroide7311703oroid_e
prossie91812953prossie
prostie91617743prostie
provide1339853provide
roadies83317433_roadies
rode55844303_ro_d_e
roofie93411173_roofie
rookie103613263_rookie
roomie83013873_roomie
rowdiest12259213_rowdiest
rowdily1436083_rowdily
rowdy125711533_rowd_y
shrewdie1542973shrewdie
towie85821873_tow_ie
townie93312303_townie
trode65322853tro_d_e
woodie103513613_woodie
yowie114616453_yow_ie
zowie174313843_zow_ie

Search took 9 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 Limit1340271378.03016690.8
3Display Results1371370.0632174.6
 (SQL Overall)1786911378.24921662.1
 
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.