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

119 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
fenland113569(None) 
fenlands1245181fenlands
eland65820392_e_land
inland7310312_inland
reland75920432re_land
sunland837472sunland
wetland1135352wetland
aland65526413__aland
badland1147653badland
beglad10138463begla_d
belaud939133be_laud
benchland1743083benchland
bland85320453__bland
demand104314253de_mand
deodand1035713deodand
deplane10311413deplane
deplaned1238653deplaned
desand84812633de_sand
downland1364533downland
dryland1254303dryland
duneland1043343duneland
elan46734243_e_lan_
elands74914773_e_lands
elans55527753_e_lans
enlace82213233_enlace
enlaced102410523_enlaced
enplane939723_enplane
enplaned1137473_enplaned
enwind10298083_enwind
errand758793_errand
expand16236573_expand
fahlband1742643fahlband
farmland1454233farmland
fecund1235433fe_cund
feeling113617073feeling
felid94717173fe_l_id
feline94820143fe_line
fella84918653fella__
fellah124910773fella_h
fellahs13428393fellahs
fellas95116963fella_s
fellate10313433fellate
fellated1239563fellated
felled103720303fe_lled
felling113321133felling
felon84619293fe_lon_
felons93615763fe_lons
felony123710323fe_lony
felted103714653fe_lted
fenced124412713fen_ced
fencing132411133fencing
fend84832973fe___nd
fended114216913fen_ded
fending123717603fending
fenny115115133fen__ny
fentanyl1442533fentanyl
filmland1443153filmland
flan76134183f__lan_
flank124618093f__lank
flans85327973f__lans
flatland1264963flatland
fondant11311143fondant
foreland1239013foreland
foulard11257283foulard
freehand1574993freehand
gangland1145193gangland
garland948703garland
gelant72821673ge_lant
gellant83214053gellant
gland75217713__gland
headland1345613headland
henbane1237353henbane
hennaed1135103hennaed
holland11349473holland
inlaid7310133_inlaid
inlands838783_inlands
island738533_island
lalland83810173lalland
land56337303___land
lentando943603lentando
lowland1134693lowland
mainland1145213mainland
menad85918983men_a_d
midland1136603midland
norland837163norland
outland81212343outland
overland122312003overland
penang92511113pen_ang
pendant10314853pendant
penman10312323penman_
pennant9312493pennant
pentad9313763penta_d
pentane9415743pentane
pineland1145893pineland
reblend1036653reblend
reclad9311873recla_d
relaid75518443re_laid
relands85214883re_lands
relend76116453re_lend
remand95618963re_mand
repand95316063re_pand
replan83215823replan_
replans92814943replans
replant93318533replant
rimland1035663rimland
sealant73118303sealant
shetland1244633shetland
soland75115043_soland
sunlands936383sunlands
tenant6322473ten_ant
troland837543troland
unhand10410383_unhand
unlaid7311753_unlaid
upland938863_upland
weasand1135503weasand
weazand2043613weazand
wessand1144833wessand
wetlands1244763wetlands
zenana15297983zen_ana

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.1531167915.0
2DLD Change Limit1340271196.90619407.3
3Display Results1191190.0502380.0
 (SQL Overall)1786911197.10925135.9
 
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.