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

212 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
limbate113921(None) 
climate11312832clim_ate
lambaste12145012lambaste
librate93214232librate
ligate72519252li_gate
limba95414982limba__
limbas105313202limba_s
limeade1076122limeade
lineate7815152lineate
liquate1638422liquate
lobate82915242l_obate
niobate937702niobate
timbale11248802timbale
abate76627843__abate
airdate8311323airdate
alienate8311553alienate
ambage11510603_ambage
amirate91115953amirate
animate91617213anim_ate
barbate11314543barbate
bate66552423___bate
bilobate1247033bilobate
bimbette1444753bimbette
binate8419773bi_nate
bistate9313823bistate
celibate1259313celi_bate
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
clambake1843893clambake
climates12311973clim_ates
climbable1743603climbable
comate104124843com_ate
combat12316753combat_
combated1539823combated
combater1439383combater
combats13311683combats
debate94419193_debate
diabase1037113diabase
dictate10311663dictate
dilate73220693di_late
disrate81418523disrate
eliminate1147733eliminate
emirate91015833emirate
filiate10414233filiate
fimble133611753fimb_le
fimbriate1643823fimbriate
fissate103010033fissate
fixate1638733fi_xate
gambade1336383gambade
gemmate12418383gemmate
gimbal11228813gimba_l
gimbaled14104173gimbaled
gimbals12257823gimbals
globate1057823globate
hamate113319833ham_ate
humate113214443hum_ate
ideate7313683_ideate
image81411293_im_age
imamate1138103_imamate
imbalm1246323_imbalm
imbark14347863_imbark
imbibe1234703_imbibe
imblaze2044323_imblaze
imbrue1035153_imbrue
imbrute1144913_imbrute
imbue939483_imb_ue
imitate9310873_imitate
immane1038883_immane
impale102811663_impale
impaste11258003_impaste
impute1038043_impute
ingate73018243_ingate
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
irate55627983_i_rate
labiate91313573labiate
lactate9312703lactate
lambada1245643lambada
lambast11129893lambast
lambasted14103253lambasted
lambastes13114693lambastes
lambasts12145623lambasts
lambie103213673lamb_ie
lamiae84817453lamia_e
laminate103014633laminate
lanate6421263l_anate
late47560483l___ate
legate72917453l_egate
lemmata1144673lemmata
liable81415813liab_le
liane54720663li__ane
liberate101113383liberate
librae84310173li_brae
librated113110313librated
librates103412953librates
licente91210893licente
liftgate1243413liftgate
ligase7259913li_gase
ligated92414143li_gated
ligates82318383li_gates
lignite81310303lignite
ligulate92510253ligulate
likable13219413likable
lima65734143lim_a__
liman75921603lim_a_n
limans84816303lim_ans
limas75627633lim_a_s
limb85429393limb___
limbeck1744173limbeck
limbed114513183limb_ed
limber104316793limb_er
limbered13158123limbered
limberer12187053limberer
limbers113614743limbers
limbi96513813limb__i
limbic12528743limb_ic
limbier11349113limbier
limbing123410423limbing
limbo95614813limb__o
limbos104712143limb_os
limbs96118943limb__s
limbus105710383limb_us
limbuses1234903limbuses
limby125714073limb__y
lime66244943lim___e
limeades11116643limeades
limewater1444073limewater
limit73126343lim_it_
limited102310233lim_ited
limiter92710853lim_iter
limites92915453lim_ites
limits82514143lim_its
limonite1048163limonite
limpa97014463limpa__
limpas105513083limpa_s
limpet103518633limpet_
limpets11329783limpets
linable92214343linable
linage7713403li_nage
lindane839033lindane
lineage878983lineage
lineated9711063lineated
linkage1295963linkage
lipase8239103li_pase
liquated1835493liquated
liquates1737453liquates
lisente71210703lisente
lite47054553li___te
literate81216893literate
litigate948303litigate
livable122010323livable
lobated102610943l_obated
locate83919843l_ocate
lumbago1243833lumbago
lumbar103610593lumba_r
lumbars11289763lumbars
lunate6316043l_unate
luxate1338083l_uxate
lyrate94112103l_yrate
lysate9388103l_ysate
mammate104411273mammate
mate65154223__m_ate
migrate101314173migrate
mimbar1297493mimba_r
mimbars1397383mimbars
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
nictate9310223nictate
nidate7313783ni_date
nimble103412943nimb_le
niobates1037283niobates
niobite937953niobite
nitrate72017013nitrate
numbat10312083numbat_
numbats1137673numbats
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirate82322883pi_rate
plicate11314513pli_cate
plumate1149803plum_ate
primate111516283prim_ate
probate11414483probate
ramate83921693ram_ate
rebate84424113_rebate
remate84428683rem_ate
sigmate10710143sigmate
simulate10311133simulate
sinuate7412163sinuate
situate7410783situate
sorbate9311733sorbate
summate113611663summate
timbal102510753timba_l
timbales12227843timbales
timbals11239533timbals
timbre10328633timb_re
titrate72215573titrate
tubate82813173_tubate
ultimate1049203ultim_ate
vibrate122811523vibrate
violate10311553violate
virgate1138733virgate
vitiate103412953vitiate
vittate10409733vittate
wimble133211923wimb_le
wombat1339863wombat_
wombats1435893wombats
zincate1838533zincate

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 Limit1340272126.42320866.7
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.90525878.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.