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

121 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
roble7522302(None) 
coble94823171coble
noble74420991noble
robe65335641rob_e
robles85321691robles
role45851821ro_le
rouble83913311rouble
ruble74521251ruble
able66340532_able
amble95924642amble
arable81821002arable
bible95119422bible
bobble94115142bobble
bogle85821682bogle
bole66448692bo_le
boule74828042boule
cable95329912cable
cobble123615262cobble
cobles104622882cobles
cole66956112co_le
doable93115242doable
dobie84920332dobie
dobla84913642dobla
dole56550002do_le
double94013992double
fable105824752fable
foible11410382foible
gable85325522gable
gobble113512982gobble
goblet93219482goblet
hobble133913432hobble
hole77553392ho_le
hoyle11314412hoyle
jole117233822jo_le
joule124918202joule
lobe65535362lob_e
lobule82910062lobule
mobile103613542mobile
mobled113213182mobled
mole66251832mo_le
nobble103814312nobble
nobler83713452nobler
nobles83319722nobles
nobly105314402nobly
obe56638642_ob_e
oboe66822942_oboe
obole75917142_obole
ogle56325052_ogle
ole37155212_o_le
orle45630462_orle
pole65951302po_le
probe94320812prob_e
problem1335982problem
prole74527792pro_le
rabble103818242rabble
rale45050562r_ale
ramble104519972ramble
rebbe9313162rebbe
rebel73421292rebel
riblet84222442riblet
rifle85518332rifle
rile45650542r_ile
rille55728732rille
rob56754302rob__
robalo838932robalo
robbed113415192robbed
robber103916532robber
robed85323732robed
robes75133302robes
robin74820282robin
robot7325972robot
robs65837872rob_s
rode55844312ro_de
roe36861082ro__e
rogue66417532rogue
roil46235292roil_
roiled74320052roiled
roils54826792roils
roily86121112roily
roles56747982ro_les
rolf75134872ro_lf
roll46331652ro_ll
rolled74220242rolled
roller63919792roller
rolls55326232rolls
roose56127092roose
rootle63214452rootle
ropable111611332ropable
rope65542912ro_pe
roque144812132roque
rose46148902ro_se
rote46249022ro_te
rotl45029682rotl_
rotls55620162rotls
rotte54625932rotte
roubles93413512roubles
roue45941742ro_ue
rouge65423442rouge
rouse56634702rouse
route55132072route
rove75136982ro_ve
rowable121510302rowable
rowel84721412rowel
rubble104315672rubble
rube65532012rub_e
rubel75416832rubel
rubles83921702rubles
rule49938422r_ule
rumble103718812rumble
sable74732162sable
socle7419572socle
sole46053672so_le
table75429602table
toile54626492toile
tole46052902to_le
treble8311662treble
trouble957712trouble
voile84719722voile
vole75236982vo_le
wobble133212312wobble
yodle94515042yodle

Search took 3 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.296603685.8
2DLD Change Limit538001211.67332157.8
3Display Results1211210.0333666.7
 (SQL Overall)1786911212.00289256.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.