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

186 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
ramilie931028(None) 
ramilies10311831ramilies
ramillie1045861ramillie
bailie83818362ba_ilie
families1339442families
ramble104519972rambl_e
ramie75027822ram__ie
ramified1438042ramified
ramifies13310502ramifies
ramillies1146132ramillies
agile65122263_agil_e
amble95924643_ambl_e
amice96122873_ami_ce
amici94217393_amici_
amide86128493_ami_de
amidic114012873_amidic
amidin94015673_amidin
amidine103613853_amidine
amie66339853_am__ie
amine75835383_ami_ne
aminic104413513_aminic
amities9317383_amities
amole75724593_amol_e
ample94720303_ampl_e
amylic13108713_amylic
anile54634463_anil_e
anilin6417793_anilin
aniline7418473_aniline
armilla936993armilla
armillae1045563armillae
armlike1348553armlike
axile126020513_axil_e
bailee84526013ba_ilee
bailies94120203ba_ilies
basilic1137493basilic
braille939713bra_ille
bramble133710033brambl_e
bramblier1543503bramblier
brasilin1046963brasilin
brawlie12198153bra_wlie
brazilin1944383brazilin
camelia11510443camelia
camelid1249413camelid
camise103319633cami_se
camisia112810243camisia
cammie124615293cam_mie
cramoisie1343393cramoisie
dailies84219263da_ilies
dominie103111643dominie
facile112514883facil_e
faille93414743fa_ille
familial1366083familial
familiar1365953familiar
familism1546343familism
family143311703famil_y
famine114318193fami_ne
famuli1136763famuli_
feminie12179933feminie
fragile1147843fragil_e
galilee8312213galilee
gamble115417183gambl_e
gamelike1538033gamelike
gamily123712183gamil_y
gamine94620153gami_ne
gracile102512603gracil_e
gracilis11247033gracilis
habile11515213habil_e
hamuli1137063hamuli_
homilies132710113homilies
jamlike20126923jamlike
labile8315223labil_e
lambie103213673lam_bie
lamblike1636153lamblike
lamiae84817453lami_ae
laminae93512973laminae
laminin939973laminin
maile75232223ma_il_e
mamie95826003mam__ie
mammie94313783mam_mie
manille92613273manille
mile66352583__mil_e
milia72719573__milia
milieu8314113__milieu
mille75029133__mille
mislie83219153__mislie
prairie938333pra_irie
rabble103818243rabbl_e
racialize2049203racialize
racily11715173racil_y
rackle123917293rackl_e
raddle84816173raddl_e
radiale83813523radiale
radialia946323radialia
radiate83416313radiate
radicle103510713radicle
radii64016413radi_i_
radulae837963radulae
raffle123910703raffl_e
raggle83712883raggl_e
rail46147763ra_il__
railed74727543ra_iled
railer64524933ra_iler
railing83325643ra_iling
rails55937403ra_il_s
rainier71614263ra_inier
raise54828053ra_i_se
raisin62716923ra_isin
rale45050563ra__l_e
rallied83514083ra_llied
rallier73816283ra_llier
rallies73823343ra_llies
ralline73518413ralline
rallye95110163ra_llye
ramal74622253ramal__
ramate83921693ram_ate
rambla103510933rambl_a
ramblas112710263ramblas
rambled123913523rambled
rambler113313263rambler
rambles113118313rambles
rambling131810773rambling
ramee74633853ram__ee
ramekin13126493ramekin
rami66034093ram__i_
ramies84630463rami_es
ramify14268753rami_fy
rammier112811023ram_mier
ramose8314403ram_ose
rampage1237453rampage
rampike1536603rampike
rampole1139693rampole
ramtil8311033ram_til
ramtilla1054733ramtilla
ramtils938413ramtil_s
ramulose1044313ramulose
rankle103414883rankl_e
rapine85023083rapi_ne
rapini84714683rapini_
rarified1239053rarified
rarifies11311943rarifies
rarities8316333rarities
rashlike1535793rashlike
rassle63813203rassl_e
raticide1148943raticide
ratified12310503ratified
ratifier1139673ratifier
ratifies11313513ratifies
ratine65131823rati_ne
ratite65022423rati_te
ratlike113912353ratlike
ratlin64116523ra_tlin
ratline74517803ratline
rattle64717613rattl_e
ravelin102211023ravelin
ravine95522223ravi_ne
ravioli1055613ravioli_
raviolis1146103raviolis
raylike14269253raylike
refile95122373refil_e
remise84221953remi_se
resile64627673resil_e
resilin72913973resilin
retile65929673retil_e
revile94921613revil_e
rile45650543r__il_e
rille55728733r__ille
rimple103814583rimpl_e
roilier7311523r_oilier
rouille737493rouille
rumble103718813rumbl_e
rumple103913013rumpl_e
rumplier1235303rumplier
rutile65217683rutil_e
samite83020603sami_te
sample104215013sampl_e
simile83115633simil_e
smile74823923_smil_e
taille63116923ta_ille
tamale83717403tamal_e
tammie104212693tam_mie
tramline10311383tramline
trample11299703trampl_e
vagile10310543vagil_e
wallie93216803wa_llie
wamble134415753wambl_e
wamblier15275733wamblier

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.406440125.6
2DLD Change Limit1340271867.11018850.5
3Display Results1861860.0603100.0
 (SQL Overall)1786911867.57623586.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.