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

139 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
lipread103495(None) 
lipreads1144221lipreads
dispread1247102dispread
lipped114419542lippe_d
lipreader1243292lipreader
misread10339722misread
spread9312532_spread
aired66032923ai_re_d
airhead1136993airhead
aliped95414283alip_e_d
bespread1344183bespread
bighead14126653bighead
biped104718833bip_e_d
birred94713203birre_d
blipped14377193blippe_d
bread85523113__bread
clipped14439833clippe_d
copyread1643783copyread
dipped123517493dippe_d
dispreads1346003dispreads
dread74419023__dread
fired94829743fi_re_d
flipped15358513flippe_d
gipped124815903gippe_d
hipped144317693hippe_d
hired95226263hi_re_d
hophead16337923hophead
implead12315823implead
inroad737933_inroad
ired55131873_i_re_d
irreal657833_irreal
kipped153114573kippe_d
laired75216813laire_d
lapped114320033lappe_d
lapsed94712583lapse_d
laterad8310843laterad
lead56038853l___ead
leered73816223leere_d
liard65418593liar__d
liberal9310193liberal
libra74712423libr_a_
librae84310173libr_ae
libras83711703libr_as
licked134621563licke_d
lidded93410243lidde_d
lied55838093li__e_d
lifted104413523lifte_d
liked104523813li_ke_d
lilied73913213lilie_d
lilted73715373lilte_d
limbed114513183limbe_d
limeade1076123li_meade
limed85426803li_me_d
limned94811473limne_d
limped114817123limpe_d
lineal65616023li_neal
linear65113343li_near
lined64934643li_ne_d
linked114518213linke_d
linseed838203linseed
linted74021823linte_d
lipa68425923lip__a_
lipe66839733lip_e__
lipid85916173lip__id
lipless9259553lipless
lipoid9411043lip_oid
lipoma1046753lipoma_
lipomas1156443lipomas
lippen103911403lippe_n
lippened13255223lippened
lippens11328533lippens
lipper104219633lippe_r
lippered13287953lippered
lippers113416443lippers
lipreaders1342843lipreaders
lipreading1444043lipreading
lira46928683li_r_a_
liras56021983li_r_as
lire47845293li_re__
lisped94113423lispe_d
listed74322833liste_d
literal7613273literal
litre55421463litre__
litres65220393litre_s
lived95523723li_ve_d
livered113111633livered
livre85613253livre__
livres94311863livre_s
loped85128333lop_e_d
lopped114218623loppe_d
loreal63814313l_oreal
loured74617403loure_d
lured65427493l_ure_d
mired85729223mi_re_d
mislead10419973mislead
misplead1345023misplead
misreads11268923misreads
mitred94414343mitre_d
nipped113615853nippe_d
oread64619603__oread
outread82811093outread
pinhead13347073pinhead
piped105123163pip_e_d
pipped104516543pippe_d
pithead13419593pithead
plead85818463__plead
preed85128123__preed
read55942533___read
replead10399013replead
reread71715433_reread
respread1135433respread
retread849003retread
riped85226433rip_e_d
ripped114419013rippe_d
riprap1055513ripr_ap
saphead1357773saphead
siped84927683sip_e_d
sipped113720633sippe_d
sired66134283si_re_d
sliped95417063slip_e_d
slipped124711743slippe_d
spirea84015633spirea_
spireas94412513spireas
spired94921863spire_d
spreads1039763_spreads
thread105011093_thread
tiaraed837053tiaraed
tiered73613973tiere_d
tipped114418263tippe_d
tired65228903ti_re_d
tread64821703__tread
unread73412673_unread
untread857413untread
uprear8168793_uprear
wiped114722083wip_e_d
wired95327643wi_re_d
yipped143613283yippe_d
yirred10426963yirre_d
zipped203612983zippe_d

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.403443402.0
2DLD Change Limit1340271396.50020619.5
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.94925714.6
 
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.