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

170 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
finances133865(None) 
fiances12310671fi_ances
finance1238571finance_
financed1435111financed
cofinances1745302cofinances
faineances1553522faineances
fiance11310742fi_ance_
fiancee1238952fi_ancee
fiancees1335102fi_ancees
finagles12237552finagles
finales104016012fina_les
financier1443712financier
financiers1542382financiers
inanes62519802_inan_es
nances83618642__nances
penances12312442penances
pinnaces12268862pinnaces
refinances15107132refinances
sonances10310262sonances
abidances1445593abidances
advances1445613advances
affiances1745153affiances
anankes1138763_anankes
balances1279973balances
bifaces1448063bifa_ces
binaries10314183binaries
binnacles13244583binnacles
brisances1345843brisances
chances145218093_chances
cofinance1645553cofinance_
cofinanced1843163cofinanced
dances95120653__dances
defiances1557033defi_ances
distances12311653distances
dominances1545683dominances
durances1158683durances
eminences1347403eminences
enhances1339293enhances
faces106439433f__a_ces
faeces114713123f__aeces
faiences1337043faiences
faineance1443363faineance_
falces115216003f__alces
fancies124018783f__ancies
fanes84639893f__an_es
fannies103415643fan_nies
farces115223323f__arces
fasces114914543f__asces
fauces114916153f__auces
feasances1445403feasances
fenagles12186083fenagles
fences114617113f__ences
fennecs12305693fen_necs
fiacres1237253fi_acres
fiascoes13134923fi_ascoes
fiascos12124743fi_ascos
fibrannes1443533fibrannes
fices106031163fi___ces
filarees1187643filarees
finable122213623finable_
finagle11238313finagle_
finagled13205293finagled
finagler12194953finagler
finaglers13173893finaglers
finale94116763fina_le_
finalis103313663fina_lis
finalise113112573finalise
finalises122911523finalises
finalizes212810743finalizes
finals94316163fina__ls
financial1443683financial
financing1544073financing
financings1641853financings
finbacks1965363finbacks
fincas113512073fi__ncas
finches153914193fin_ches
fineness11310643fineness
fineries112416743fineries
fines86644263fi__n_es
finesses111912343finesses
finings114311773finin_gs
finises10312903fin_ises
finishes1438983finishes
finites10315923fin_ites
finned104114603fin_n_ed
finnier10319953fin_nier
finniest113011403fin_niest
fixates1737393fixa_tes
flanes94522423f_lan_es
flanges113413273f_langes
flounces1335103flounces
francs114112193f_ranc_s
frounces1336183frounces
funnies104113603fun_nies
furanes103214863furan_es
furnaces1336053furna_ces
glances104113143_glances
guidances1344773guidances
hances115621283__hances
hindrances1644843hindrances
hinnies103615103hin_nies
inane52820343_inan_e_
inaner62213543_inan_er
inanest72115363_inan_est
inarches1358043_inarches
indices103513443_indices
induces103611813_induces
infancies1446973_infancies
infantes11249633_infantes
inlaces92512903_inlaces
innages82911303_innages
instances1148753_instances
joyances2044413joyances
kinases113511123kina_ses
laitances1145613laitances
lances84824103__lances
lianes63819323li_an_es
licences12129323licences
linacs8310813lina_c_s
linages8813173lina_ges
lindanes939173lindan_es
litanies8310993litanies
luminances1444473luminances
menaces112715523mena_ces
minces104420803mi__nces
minnies93617363min_nies
nance74721843__nance_
nancies93516843__nancies
ninnies73713613nin_nies
nonces84418833__nonces
nondances1247803nondances
nuances938523_nuances
nuisances1145333nuisances
ordinances1344973ordinances
ordnances1244753ordnances
penance11313443penance_
penanced1338163penanced
pinangs10267793pinan_gs
pinenes93416673pinen_es
pinnace113510313pinnace_
pinnacles13276043pinnacles
pinnies93318443pin_nies
pinones94717073pinon_es
piquances2244053piquances
pittances1345703pittances
poignances1543443poignances
prances113618773_prances
prefinances1875013prefinances
rances84625443__rances
refinance14117643refinance_
refinanced16144763refinanced
riddances1343893riddances
romances12310793romances
seances93015343_seances
silanes72517163silan_es
silences10310073silences
sonance9310313sonance_
stances93715963_stances
tenaces92814513tena_ces
tenancies1149173tenancies
tendances1247573tendances
tisanes7311853tisan_es
trances93919643_trances
usances967373_usances
valances1398763valances
vibrances1645763vibrances
vinasses1135703vinasses
vivaces1536413viva_ces
voidances1544473voidances
winces114819113wi__nces

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621706.45622639.7
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.95225703.5
 
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.