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

116 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
rimland103566(None) 
rimlands1145241rimlands
filmland1443152filmland
inland7310312_inland
island738532_island
midland1136612midland
reland75920432r_eland
remand95618962rem_and
riband9239622ri_band
ribband1245582ribband
aland65526413__aland
armband1265983armband
badland1147653badland
biplane1139033biplane
bland85320453__bland
brigand1136643bri_gand
command14399213command
cropland1346303cropland
demand104314253dem_and
disband1138243disband
dreamland1342073dreamland
dryland1254303dryland
eland65820393__eland
farmland1454233farmland
fenland1135693fenland
filmlands1542903filmlands
garland948703garland
gland75217713__gland
highland16114533highland
holland11349473holland
homeland1446243homeland
immane1038883_immane
impend11478793_impend
implant11311333_implant
inlaid7310143_inlaid
inlands838783_inlands
islands837323_islands
lalland83810183lalland
land56337313___land
ligand85011293li_gand
liman75921603lim_an_
limans84816303lim_ans
lowland1134693lowland
mainland1145213mainland
midlands1245543midlands
mislaid1039303mislaid
norland837163norland
oilman839483oilman_
outland81212343outland
pineland1145893pineland
raglan73711503raglan_
raglans82410133raglans
rainband1144663rainband
rampant11312173rampant
rand55839573r___and
reblend1036653reblend
reclad9311873recla_d
reimplant1395303reimplant
relaid75518443r_elaid
relands85214883r_elands
relend76116453r_elend
reman75730153rem_an_
remands104914883rem_ands
remans84823003rem_ans
remend95216553rem_end
remind94819793rem_ind
remnant9312643remnant
repand95316063r_epand
replan83215823replan_
replans92814943replans
replant93318533replant
riant55833153ri__ant
ribald9209293ri_bald
ribands10208393ri_bands
ribbands1344563ribbands
rifled104115003rifl_ed
rifling112815013rifling
riled65833253ri_l_ed
riling74227973ri_ling
rilled74525653ri_lled
rilling84023623rilling
rimed84826373rim__ed
riming93322223rim_ing
rimless9369363rimless
rimmed114812303rim_med
rimming123411073rimming
rimpled123311423rimpled
rimpling13219663rimpling
rind56535603ri___nd
ritard74812083ri_tard
rivaled1138933rivaled
roband92310723r_oband
roman75424823rom_an_
romano84912943rom_ano
romans84620243rom_ans
rumbaed12287493rumbaed
silane62718053si_lane
simian8811163simian_
simians959203simians
simlin8311733simlin_
simlins9311843simlins
simulant1048083simulant
soland75115043_soland
summand1236263summand
sunland837473sunland
tideland1044633tideland
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
triclad1037443tricla_d
triplane1039113triplane
troland837543troland
upland938863_upland
viand9511073vi__and
wetland1135353wetland
wildland1353843wildland

Search took 7 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 Limit1340271166.15621771.8
3Display Results1161160.0333515.2
 (SQL Overall)1786911166.59527094.9
 
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.