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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
felid9471717(None) 
felids103111621felids
fetid93715981fetid
gelid74916981gelid
belie75630382belie
belied95022162belied
cebid104314072cebid
deled75326542deled
deli55631292deli_
delis64928542delis
eld46733792_el_d
elide64922642_elide
eyelid1038442eyelid
fed76548352fe__d
feed84538902fe_ed
feline94820142feline
fell76833072fel_l
fella84918652fella
felled103720302felled
fells85327382fells
felly114922802felly
felon84619292felon
felsic1147052felsic
felt75146932fel_t
felted103714652felted
felts85324542felts
fend84832972fe_nd
feod815523002fe_od
feria85922712feria
ferlie92814052ferlie
fervid1337512fervid
feted94420932feted
feud86523022fe_ud
feued94715662feued
fid76847692f__id
field95015322fiel_d
filed95331902filed
fjeld16465582fjel_d
fled85429772f_led
flic96223732f_lic
flied96519432f_lied
flip96324262f_lip
flir76422202f_lir
flit76539272f_lit
fluid94013962fluid
foetid10510512foetid
fold86528942fol_d
folia83618932folia
folic105319322folic
folio83820882folio
fueled104913602fueled
fulgid1137042fulgid
geld65828432gel_d
geoid74215762geoid
halid94424982halid
held85330402hel_d
helio85321192helio
helix154413012helix
jerid132316422jerid
kelim11912552kelim
keloid11812622keloid
lid47453522__lid
meld75830472mel_d
melic94722332melic
meloid9616002meloid
rebid85121362rebid
redid74922392redid
relaid75518442relaid
relic74623362relic
relied74926232relied
relit55340682relit
resid64124092resid
slid55828982_slid
solid65025082solid
teiid6312532teiid
telia55821142telia
telic76019822telic
tepid8314312tepid
valid94618392valid
veld85323202vel_d
weld84727732wel_d
yeld811423872yel_d

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.393454684.5
2DLD Change Limit53800821.42037887.3
3Display Results82820.0165125.0
 (SQL Overall)178691821.82997698.7
 
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.