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

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

151 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
coude8502263(None) 
code77347731co_de
coupe96023481coupe
crude86018571crude
bode75838752bo_de
boule74828042boule
bouse75931852bouse
cade76443912c_ade
caudex1636392caudex
caudle93912912caudle
cause75225352cause
cede74928762c_ede
chide115321012chide
chouse116017562chouse
chute104316462chute
clade85821012clade
cloud86716422cloud_
clouded11348832clouded
clouds94612352clouds
cloudy12517802cloudy
clue65324532clu_e
clued84917682clued
coble94823172coble
cod69660122co_d_
coda77029342co_da
codded114515302codded
codder104416332codder
coddle104713852coddle
codec107120342co_dec
coded95433182co_ded
coden86128542co_den
coder86134212co_der
codes86247292co_des
codex155817572co_dex
cods76848102co_ds
coed77140542coed_
coeds85920162coeds
cohune1189422cohune
coke107038382co_ke
coked124730692coked
cold77338772cold_
colder95121832colder
colds85726972colds
cole66956112co_le
coled85540752coled
collude10337982collude
colure8314152colure
comade114415322comade
comae97128422comae
combe116223542combe
come87547702co_me
comte96125472comte
condo85322592condo
cone67256962co_ne
coned86040052coned
conge85227592conge
conte76633202conte
cooed84534342cooed
cooee74531022cooee
cope86847382co_pe
coped105036842coped
copse95623922copse
cord76740922cord_
corded105923352corded
corder94322872corder
cords86030622cords
core67263112co_re
cored85044222cored
corse75036182corse
cosie74728262cosie
cote66648732co_te
coted85033852coted
couch125320112couch
cough115819642cough
could86517712could
coulee8323502coulee
count74932052count
coup86729792cou_p
couped115019312couped
coupes105022522coupes
couple104415962couple
coups95522472coups
course85117772course
court75532762court
couter84930202couter
couth106122482couth
couvade1335062couvade
cove95837072co_ve
coved115027372coved
cowed115637842cowed
coxae146115182coxae
coxed154322812coxed
coyed114623802coyed
cozie163519122cozie
croupe105114432croupe
crouse84619362crouse
croute84617272croute
crud75219612crud_
cruder95612382cruder
crudes96218622crudes
cruds85815852cruds
cruse75726102cruse
cube85830212c_ube
cud67937452c_ud_
cuds76730472c_uds
cue57544182c_u_e
cued76329562c_ued
cuke105824982c_uke
cure66149122c_ure
cute66440452c_ute
douce85518422douce
douse66329722douse
dude65629662_dude
elude64517622elude
etude63612302etude
exude134010292exude
gouge78220062gouge
gourde8107932gourde
gude65423332_gude
horde94623052horde
house89131422house
joule124918202joule
lode56240112lo_de
loud55228042loud_
louden73711792louden
louder74414602louder
louie55023512louie
loupe75319512loupe
louse56131012louse
lude55331642_lude
mode75840302mo_de
monde85723142monde
moue65835572mou_e
mouse77133002mouse
node513036882no_de
nude56626272_nude
ode47446582_o_de
oud47439072_oud_
ouds56430102_ouds
prude84615972prude
rode55844302ro_de
roue45941742rou_e
rouge65423442rouge
rouse56634702rouse
route55132072route
rude55632782_rude
scouse84113632scouse
sonde64622832sonde
souse56530772souse
touse55430672touse
youse85322232youse

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001511.51635488.1
3Display Results1511510.0463282.6
 (SQL Overall)1786911511.655107970.4
 
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.