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

120 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
ruderal83737(None) 
ruderals946071ruderals
federal1148532federal
funeral1037622funeral
humeral1238572humeral
numeral939082numeral
puberal1147772puberal
ruder65320542ruder__
rudery10419032ruder_y
rural55821172ru__ral
sudoral8148542sudoral
apteral9311523apteral
audial7312993aud_ial
augural856403augural
aural54428963au__ral
auroral7310473auroral
austral73411513austral
butyral1245713butyral
cameral11311283cameral
cruder95612383cruder__
crural8610633cru__ral
cuneal8611513cune_al
deal56347413__de_al
decal85523233__decal
dedal75719023__dedal
derail74218813__derail
derat65044083__derat
deray95024183__deray
dermal93614343__dermal
duodenal1042563duodenal
dural64923893__dural
enteral73516443enteral
falderal12104803falderal
federals1247303federals
feral85424653__feral
funerals1146453funerals
funereal1143943funereal
futural1037283futural
general81010933general
gomeral1038843gomeral
humerals1347183humerals
humoral1237983humoral
ideal65716393_ide_al
jural125120483ju__ral
juvenal1743393juvenal
lateral7313573lateral
liberal9310193liberal
literal7613273literal
lumenal9307273lumenal
lustral7339653lustral
luteal64411483lute_al
mineral9312733mineral
mudra83912433mud_ra_
mudras94212263mud_ras
mural75225113mu__ral
nadiral836343nadiral
nuder66416833nuder__
numerals1047343numerals
ordeal779253orde_al
prudery1335243pruder_y
pubertal1254323pubertal
pudendal1242853pudendal
quezal2435143qu_ezal
radial74020393rad_ial
radical103312793radical
real45750293r__e_al
redear73515173rede_ar
redears82814453redears
redial74923113red_ial
redraw10269853red_raw
redream10107913redream
referral1144403referral
regal65023793r__egal
renal55929503r__enal
renewal1038703renewal
repeal84718283repe_al
reran57329103r__eran
reseal64819643rese_al
retral64419743r_etral
reveal94115053reve_al
reversal1145843reversal
rider65231303rider__
riders74123903rider_s
rostral7311333rostral
rubel75416833rube__l
rubella9146523rubella
rubeola9115123rubeola
rudder83812803rudder__
rudders93210653rudder_s
rude55632783rude___
rudely10389973rude_ly
ruderies9311333ruderies
rudesby1341703rudesby
rudest74016313rude_st
rueful948203ru_eful
ruer46127563ru_er__
ruers515019413ru_er_s
rugal65916093ru__gal
ruler54923343ruler__
rulers64317093ruler_s
ruminal9289993ruminal
scleral937863scleral
seral56336383__seral
several1039533several
sidereal946053sidereal
spheral1238423spheral
subdermal1443853subdermal
subdural1145883subdural
suboral92011993suboral
supernal1039873supernal
sural55931263su__ral
surreal739233surreal
sutural7310223sutural
tumoral938133tumoral
umbral1038633_umbral
unreal64414453_unreal
ureal56722683_ure_al
uredial82910483uredial
ureteral856233ureteral
uveal84411073_uve_al

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.406440125.6
2DLD Change Limit1340271207.09318895.7
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.54523683.4
 
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.