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

482 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
fiances1231067(None) 
fiance11310741fiance_
fiancee1238951fiancee
fiancees1335101fiancees
finances1338651finances
affiances1745152affiances
chances145218092chances
dances95120652_dances
defiances1557032defiances
faces106439432f_a_ces
faeces114713122f_aeces
faiences1337042faiences
falces115216002f_alces
fancies124018782f_ancies
fanes84639892f_an_es
farces115223322f_arces
fasces114914542f_asces
fauces114916152f_auces
fences114617112f_ences
fiacres1237252fiacres
fiascoes13134922fiascoes
fiascos12124742fiascos
fices106031162fi__ces
finales104016012finales
finance1238572finance_
financed1435112financed
fincas113512072fi_ncas
finches153914192fi_nches
fines86644262fi_n_es
flanes94522422flan_es
flanges113413272flanges
francs114112192franc_s
glances104113142glances
hances115621282_hances
lances84824102_lances
lianes63819322lian_es
minces104420802mi_nces
nances83618642_nances
nuances938522nuances
prances113618772prances
rances84625442_rances
seances93015342seances
stances93715962stances
trances93919642trances
usances967372usances
winces114819112wi_nces
abidances1445593abidances
aces67645093__a_ces
acnes75922623__acnes
advances1445613advances
affiance1645653affiance_
affianced1843033affianced
alliances11107093alliances
ambiances1545713ambiances
anankes1138763anankes
anes45255933__an_es
antes56334323__antes
balances1279973balances
bancos104713893_bancos
banes74945583_ban_es
beanies93821093beanies
bialies93618413bialies
biases84618433bia_ses
biasses94911653biasses
bices95029963bi__ces
bifaces1448063bifaces
bines76946793bi_n_es
binges93923123bi_nges
blanches153311603blanches
bounces113813683bounces
braces108427773bra_ces
branches153613803branches
brisances1345843brisances
calces104420053_calces
cancel105316683_cancel
cancels114113313_cancels
cancer104220923_cancer
cancers114018583_cancers
canes75350373_can_es
canoes84725883_canoes
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancels15439083chancels
chancer144215633chancer
chancers154313483chancers
chancres15429363chancres
changes134517583changes
cilices113814023cilices
cimices13279803cimices
cinches144215773ci_nches
cines75239683ci_n_es
cofinances1745303cofinances
cranches153114543cranches
cranes84330753cran_es
daces85030683_da_ces
dance85223133_dance_
danced105315253_danced
dancer94817613_dancer
dancers103413093_dancers
defiance1477633defiance_
deviances1566493deviances
diaries83321953diaries
dices86434243di__ces
dienes75719903dien_es
dines66449153di_n_es
dinges83825423di_nges
distances12311653distances
dunces95215753_dunces
durances1158683durances
effaces15277273effa_ces
enhances1339293enhances
evinces1237803evinces
fables114921673f_ables
face96140123f_a_ce_
faced117727653f_a_ced
facer105525053f_a_cer
facers115519443f_a_cers
facet106038523f_a_cet
facets116316653f_a_cets
facies113921593f_acies
facts107021893f_a_cts
fades94932863f_a_des
fadges114814023f_adges
faience1237513faience_
failles102914133failles
faineances1553523faineances
fainer94717243fain_er
fainest10417703fain_est
fainted114211723fainted
fainter103611053fainter
fainters11349693fainters
faintest1139073faintest
faints94818783fain_ts
fairies103516043fairies
fakes126032483f_a_kes
fames105735923f_a_mes
fancied133310603f_ancied
fancier123412063f_ancier
fanciers13358083f_anciers
fanciest133612713f_anciest
fancy134615483f_anc_y
fane75343563f_an_e_
fangas105017193f_angas
fanged114318223f_anged
fangs96224073f_an_gs
fanjet16311393f_anjet
fanjets1734803f_anjets
fanned104117473f_anned
fanner94218183f_anner
fanners103914653f_anners
fannies103415643fannies
fanons96115213f_anons
fanos85926503f_an_os
fans76247363f_an__s
fanums1137263f_anums
farce104925323f_arce_
farced125216533f_arced
farcer115016083f_arcer
farcers124713443f_arcers
farcies125317883f_arcies
fares85852873f_a_res
farles96025783f_arles
fashes124524023f_ashes
fates85139233f_a_tes
faucet115816553f_aucet
faucets12578443f_aucets
fauves125610423f_auves
faves115331423f_a_ves
faxes155726653f_a_xes
fazes175527213f_a_zes
feasances1445403feasances
feases95422923fea_ses
feazes184514173fea_zes
feces105625363f__eces
fence105319913f_ence_
fenced124412713f_enced
fencer114613533f_encer
fencers123810623f_encers
fennecs12305693fennecs
fiacre1137623fia_cre
fiars86720833fia__rs
fiaschi1542793fiaschi
fiasco11104923fiasc_o
fiats85324483fia__ts
fibrannes1443533fibrannes
fibres114312123fi_bres
fice95737113fi__ce_
fiches145219533fi_ches
ficoes114613463fi_coes
ficus105015493fi__cus
ficuses12159203ficuses
fiddles123212603fiddles
fidges114114383fi_dges
fiends104110293fien_ds
fierce11348913fierce_
fiercer12356953fiercer
fiercest13216143fiercest
fifes114822393fi__fes
fifties132111083fifties
figures11239103figures
filarees1187623filarees
filches153410723filches
files85441273fi__les
filles94224523fi_lles
fillies103420253fillies
fimbles143510663fimbles
finagles12237553finagles
finale94116763finale_
finalis103313653finalis
finals94316163fi_nals
financier1443713financier
financiers1542373financiers
finca104714503fi_nc_a
finch135416973fi_nc_h
finder104020233fi_nder
finders113717873fi_nders
finds95424823fi_n_ds
fine75147953fi_n_e_
fined94930503fi_n_ed
finer85431563fi_n_er
finest94321733fi_n_est
finger104920333fi_nger
fingers113418433fi_ngers
finis86824263fi_n_is
finises10312903finises
finites10315923finites
finked144214623fi_nked
finks125424223fi_n_ks
finless102810783fi_nless
finned104114603fi_nned
finnier10319953finnier
finniest113011403finniest
finos86226953fi_n_os
fins75849093fi_n__s
fipples14298653fipples
fiques1837973fi_ques
fires85740753fi__res
firns86018543firn__s
fiscs105311883fi_sc_s
fishes125221343fi_shes
fitches153516193fitches
fitness10299393fitness
fives116027363fi__ves
fixates1737383fixates
fixes154723593fi__xes
fixures17596063fixures
fizzes174512553fi_zzes
fizzles18339063fizzles
flacks154114533fla_cks
flakes134118873fla_kes
flambes14419503flambes
flames114723693fla_mes
flange103411973flange_
flanged123810843flanged
flanger113412623flanger
flangers123311373flangers
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flankers15349303flankers
flanks133913403flan_ks
flannel1035423flannel
flannels1134843flannels
flans85327973flan__s
flares94521703fla_res
flashes133916103flashes
flaxes165015353fla_xes
fleeces12399643fleeces
flenches163410533flenches
flenses1039473flenses
flinches16358953flinches
flounces1335103flounces
forces114422133f_orces
fornices1369103fornices
fracas11311993fra_cas
fraises104215693fraises
frames115119863fra_mes
franc104615413franc__
francizes2346793francizes
franked153610053franked
franker143510183franker
frankers15348353frankers
frankest1536963frankest
franks134912733fran_ks
frappes14328383frappes
frasses104314513frasses
frenches163311633frenches
friaries11310083friaries
fringes113514103fringes
frontes104214163frontes
frounces1336183frounces
funnies104113603funnies
furanes103214863furan_es
furnaces1336053furnaces
fyces139813643f__yces
giantess933893giantess
giants74713503gian_ts
glaces94218023gla_ces
glance94312313glance_
glanced11439233glanced
glancer103710073glancer
glancers11408003glancers
glandes95413833glandes
graces94523493gra_ces
granges93516523granges
guidances1344773guidances
hance105424153_hance_
hanses95022633_hanses
hinges105121023hi_nges
hinnies103615103hinnies
ibices10398163_ibices
ices66129643_i__ces
inanes62519803_inanes
incest82918743_i_ncest
inches114419673_i_nches
incus73315053_i_ncus
janes124928123_jan_es
jaunces16307423jaunces
jinxes20428233ji_nxes
joannes1436243joannes
jounces16369853jounces
joyances2044413joyances
kanes95529373_kan_es
kiangs11378363kian_gs
kinases113511123kinases
kines95039133ki_n_es
laces76141763_la_ces
laitances1145613laitances
lance75126723_lance_
lanced93717723_lanced
lancer84319973_lancer
lancers93616643_lancers
lancet84223573_lancet
lancets93411163_lancets
lanes54946793_lan_es
launces9329003launces
liaises7311053liaises
lianas63713383lian_as
liane54720663lian_e_
liangs74410593lian_gs
licences12129323licences
linacs8310813linac_s
linages8813173linages
lines57054573li_n_es
litanies8310993litanies
maces97139963_ma_ces
manches143818623_manches
manes76648953_man_es
manges94628943_manges
manses84225513_manses
mantes84430783_mantes
meanies93620743meanies
menaces112715523menaces
mince95325233mi_nce_
minced114114913mi_nced
mincer104017363mi_ncer
mincers113714843mi_ncers
mines75651953mi_n_es
minkes124618783mi_nkes
minnies93617363minnies
minxes154612983mi_nxes
nance74721843_nance_
nancies93516843_nancies
nieces84112713ni_eces
nines55937343ni_n_es
ninnies73713613ninnies
nonces84418833_nonces
nuance859043nuance_
nuanced1036203nuanced
nuisances1145333nuisances
offences1645023offences
oranges84215333oranges
ounces83617773_ounces
paces96741113_pa_ces
painches1588913painches
panes76148693_pan_es
pannes85522853_pannes
peaces106324083pea_ces
penances12312443penances
piaffes15115053piaffes
pianos84315933pian_os
pians75126963pian__s
pieces104217273pi_eces
pierces113411193pierces
pincer104019173pi_ncer
pincers113916503pi_ncers
pinches144117933pi_nches
pines76048863pi_n_es
pinnaces12268863pinnaces
pinnies93318443pinnies
piquances2244053piquances
pittances1345703pittances
places104323703pla_ces
plaices11411143plaices
planches153111863planches
planes85028083plan_es
pliancies1346673pliancies
ponces104720843_ponces
pounces114113893pounces
prance104318573prance_
pranced123714043pranced
prancer113613383prancer
prancers123210333prancers
princes113015143princes
quinces183210433quinces
races74943243_ra_ces
radiances1247693radiances
rance75028513_rance_
ranches123620113_ranches
ranees64623963_ranees
ranges73826923_ranges
refinances15107133refinances
reliances1139623reliances
rices75536153ri__ces
riddances1343893riddances
rinses64720383ri_nses
romances12310793romances
saices84221803_saices
sanes55649073_san_es
sanies63031953_sanies
sauces84919503_sauces
sciences1238773sciences
sconces113811453sconces
seance83716683seance_
sices75637273si__ces
signees83510803signees
silanes72517163silan_es
silences10310073silences
since75024173si_nce_
sines55954823si_n_es
singes74326853si_nges
sonances10310263sonances
spaces104722633spa_ces
spancel1147363spancel
spancels1245273spancels
spences113413923spences
stance84316913stance_
stanches132312793stanches
stanes64933403stan_es
taces76237803_ta_ces
tenaces92814513tenaces
thanes94918983than_es
tierces93710453tierces
tincts84510803ti_ncts
tines54848423ti_n_es
tinges74722323ti_nges
tisanes7311853tisan_es
traces85329933tra_ces
trance84718763trance_
tranced104414173tranced
tranches132915513tranches
usance858013usance_
usaunces1073373usaunces
valances1398763valances
valiances1487203valiances
vanes85130973_van_es
variances14117363variances
viands1047813vian_ds
vibrances1645763vibrances
vices105725533vi__ces
vincas113912453vi_ncas
vines85137643vi_n_es
vivaces1536413vivaces
voidances1544473voidances
wanes85040883_wan_es
wienies102213683wienies
wince105220883wi_nce_
winced124415343wi_nced
wincer115018193wi_ncer
wincers123415363wi_ncers
wincey144110383wi_ncey
winceys15395523wi_nceys
winches154714373wi_nches
wines85546863wi_n_es
winoes94317013wi_noes
winzes184313053wi_nzes
yince105214253yi_nce_
zanies153219673_zanies
zinced18419413zi_nced
zincs165312933zi_nc_s
zines145232653zi_n_es

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.1561145455.1
2DLD Change Limit1340274826.06322105.7
3Display Results4824820.1732786.1
 (SQL Overall)1786914826.39227955.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.