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

226 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
finalis10331366(None) 
finales104016011finales
finalise113112571finalise
finalism133010361finalism
finalist113014731finalist
finals94316161final_s
bialis83617162bi_alis
finagles12237552finagles
final83922032final__
finale94116762final_e
finalised13338012finalised
finalises122911522finalises
finalisms14318832finalisms
finalists123010162finalists
finality1448342finality
finalize202711022finalize
finalizes212810742finalizes
finally13310102finally
finials103210152finial_s
finis86824262fin__is
vinals94716482vinal_s
agnails837003agnails
aiolis6316843ai_olis
alkalis11148793alkalis
annalist8413753annalist
annals66415923annal_s
argalis84214193argalis
biali73419073bi_ali_
bialies93618413bi_alies
bialys11387913bi_alys
binal75323823binal__
binaries10314183binaries
binarism1248353binarism
bindis94614583bin_dis
bindles104016453bindles
bonacis11310323bonacis
bubalis11359903bubalis
canalise10816213canalise
canals84421673canal_s
cicalas1139303cicalas
dialist8517763di_alist
dials64925343di_al_s
dinars75417563dina_rs
dindles93817243dindles
dingles93818323dingles
fails85631483f__ails
falls85727653f__alls
fanatic12610703fanatic
fanatics1367183fanatics
fantails1139693fantails
fatalism13310483fatalism
fatalist11314973fatalist
females12310663females
feminazis2343153feminazis
fenagles12186083fenagles
ferals94216643feral_s
fetialis11358663fetialis
fiances12310673fiances
fiars86720833fi_a_rs
fiats85324483fi_a_ts
fibrils1236843fibrils
fibulas12228563fibulas
fiddles123212603fiddles
fields104211043fi_elds
filaria1039653filaria
files85441273fi__les
filles94224523fi_lles
fillies103420253fi_llies
fillip11268953fi_llip
fillips12298133fi_llips
fillos94415083fi_llos
fills84632373fi__lls
filmis114610283fi_lmis
films105617963fi__lms
filos86125383fi__los
fils75838703fi__l_s
fimbles143510663fimbles
finable122213623finable
finagle11238313finagle
finagled13205293finagled
finagler12194953finagler
finaglers13173893finaglers
finagling1434703finagling
finalising1446673finalising
finalities1349913finalities
finalized22279243finalized
finalizer21307923finalizer
finalizers22264903finalizers
finance1238583finance
finances1338663finances
finbacks1965363finbacks
fincas113512073fin_cas
finches153914193finches
finders113717873finders
finds95424833fin__ds
finely123011563finel_y
fineries112416753fineries
fines86644263fin__es
finfish16268193fin_fish
fingers113418433fingers
finial92814183finial__
finialed1255503finialed
finikin14266863finikin
finings114311773finings
finises10312903finises
finish124613423fin__ish
finites10315923finites
finks125424223fin__ks
finless102810783finless
finlike14279063fin_like
finmarks17154473finmarks
finos86226953fin__os
fins75849103fin___s
fipples14298653fipples
firelit10310863firelit
fiscalist1446573fiscalist
fiscals1238003fiscal_s
fixates1737393fixates
fixatif2054633fixatif
fixatifs2162073fixatifs
fizzles18339063fizzles
flails94313003f_lails
foals85721693f_oal_s
focalise131210373focalise
follis93113903f_ollis
fondles113512613fondles
frails93716473f_rails
fungals11276783fungal_s
gingalls1096433gingalls
gingals9109313gingal_s
gingelis10247093gingelis
gingilis10255593gingilis
inanes62519803_inanes
inarms8410093_inarms
inclip1036823_inclip
inclips1135963_inclips
indris7311963_indris
infalls1038943_infalls
ingles74420873_ingles
inhales10511863_inhales
inkles103515653_inkles
inlaid7310143_inlaid
inlays9389873_inlays
intis55121643_in_tis
inulin6311733_inulin
inulins7311493_inulins
invalid1146393_invalid
invalids1244743_invalids
inwalls1037283_inwalls
italic839903_italic
italics936993_italics
jingalls1685333jingalls
jingals1588073jingal_s
jingles153816383jingles
jinnis13489053jin_nis
kinaras1159123kinaras
kinas95626923kina__s
kinases113511123kinases
kindles123614843kindles
kinesis11259593kinesis
lanais6316793lana_is
linacs8310813lina_cs
linages8813173linages
linalol745093linalol
linalols844903linalols
miladis1049823miladis
minas75434113mina__s
mingles103719003mingles
minis75432993min__is
nabis76020583__nabis
nails55730403__nails
nalas55528363__nalas
naris55735293__naris
nazis145216083__nazis
ooralis7312553ooralis
oxalis1339223_oxalis
penalise101013763penalise
pibals103813083pibal_s
pignolis1146053pignolis
pilis75825203pi__lis
pinangs10267793pinangs
pinas75434453pina__s
pinatas93711503pinatas
pinballs1246933pinballs
pineals93212853pineal_s
pinoles93418713pinoles
pintails10310163pintails
pintles94118733pintles
pinwales1367963pinwales
pipals104213643pipal_s
renails74917263renails
rials55026673ri_al_s
ribalds10236673ribalds
rivals94213183rival_s
riyals94111083riyal_s
sialic8313633si_alic
sialid7314943si_alid
sialids839723si_alids
sials54227243si_al_s
signalise1046393signalise
signals8359163signal_s
sinapism1245573sinapism
singles83520433singles
sisals63013573sisal_s
snails64816653_snails
spinals93911863spinal_s
tenails73713923tenails
ticals83214713tical_s
tincals93610653tincal_s
tingles83818323tingles
tinkles113713923tinkles
unais53420773_una_is
unnails738223unnails
urinals7610263urinal_s
vials85822383vi_al_s
vinal85725813vinal__
vinas85126343vina__s
vinylic1543883vinylic
vinyls12467003vinyl_s
vitalise11310743vitalise
vitalism1339683vitalism
vitalist11313393vitalist
vitals94514303vital_s
windles113518493windles
winkles143412773winkles
wintles103414983wintles

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.516346300.4
2DLD Change Limit1340272267.26318453.4
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.87222699.6
 
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.