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

261 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
fineries11241674(None) 
pineries102419081pineries
vineries112716041vineries
wineries112316531wineries
binaries10314182binaries
binderies12311682binderies
cinerins10414102cinerins
faeries104118992f_aeries
fakeries1559832fakeries
ferneries1239042ferneries
fiberizes2346172fiberizes
fierier103511192fi_erier
fieriest112112242fi_eriest
finesses111912342finesses
fisheries1548642fisheries
flaneries1249562flaneries
joineries1648102joineries
lingeries10511812lingeries
liveries11314372liveries
miseries10320402miseries
nineties8312912nineties
niteries8318382niteries
refineries1347062refineries
veneries112815032veneries
aeries64737783__aeries
amberies122514683amberies
anergies9310453_anergies
aperies9423203_aperies
arteries8321483arteries
bakeries14312193bakeries
beaneries11310903beaneries
bibberies1297133bibberies
biners85023633biner__s
boiseries11411043boiseries
boweries13312293boweries
briberies1348333briberies
canaries10318943canaries
canneries11313083canneries
celeries10316313celeries
cicelies1269753cicelies
cineoles10109403cineoles
cinerin9313823cineri_n
congeries12316403congeries
coteries10422703coteries
deaneries10310833deaneries
diaries83321953di_aries
dimerizes2167943dimerizes
dineric10310973dineri_c
dineros83812333diner_os
diners75525953diner__s
dinettes9310193dinettes
dinghies1347363dinghies
dingies93618243din_gies
dinkies123716033din_kies
dioecies1138933dioecies
diverges13258313diverges
doweries12411933doweries
duperies11312813duperies
eateries8324313eateries
emeries91620023_emeries
emperies12314563emperies
enemies9313693_enemies
energies9310783_energies
engineries1145473engineries
entries71523163_entries
faerie93514683f_aerie_
fairies103516043f_airies
fancies124018783fan_cies
fannies103415643fan_nies
feres86038183f__er_es
ferias95020393f__erias
ferlies103216693f__erlies
ferries103521083f_erries
fiacres1237253fiacr_es
fibered1337643fiber_ed
fiberize2246143fiberize
fiberized2444533fiberized
fiberless1444453fiberless
fibers114717523fiber__s
fibres114312123fi_br_es
fibrils1236843fi_brils
fibrins1238633fi_brins
fierce11348913fi_erce_
fiercer12356953fi_ercer
fiercest13216143fi_ercest
fierily1339023fi_erily
fieriness1238623fi_eriness
fifers125414923fifer__s
fifties132111083fi_fties
figures11239113figur_es
figurines1344503figurines
filarees1187643filarees
filers94623723filer__s
fillies103420253fi_llies
finagles12237553finagles
finales104016013fin_ales
finalis103313663finali_s
finalise113112573finalise
finalises122911523finalises
finalizes212810743finalizes
finances1338653finances
finches153914193fin_ches
finders113717873finder__s
fineness11310643fineness
finer85431563finer___
finery124512893finer__y
fines86644263fin___es
finesse10187643finesse_
finessed12136793finessed
fingered13128333finger_ed
fingerer12127223finger_er
fingerers13136303fingerers
fingering1439193fingering
fingerings1545073fingerings
fingers113418433finger__s
fingertips1692773fingertips
finis86824263fin__i_s
finises10312903fin_ises
finishes1438983finishes
finites10315923fin_ites
finnier10319953fin_nier
finniest113011403fin_niest
fireflies1545353fireflies
firers94922683firer__s
fires85740753fi__r_es
firesides1346603firesides
firrier103410133fi_rrier
firriest112310433fi_rriest
fitnesses12219373fitnesses
fivepins1644083fivepins
fivers124420923fiver__s
fixers165112983fixer__s
fixities1838213fixities
fixures17596063fixur_es
flanerie1146913flanerie_
fluerics1345393fluerics
flurries11188913flurries
fooleries1248743fooleries
fopperies1666013fopperies
forgeries13310003forgeries
foundries1345693foundries
freebies1337873freebies
frenzies2037713frenzies
freres94716173f_rer_es
friaries11310083friaries
fries85535603f___ries
fripperies1743583fripperies
fulleries1248723fulleries
funerals1146453funerals
funnies104113603fun_nies
furies95126373f__uries
gantries91413793gantries
generics11118793generics
gentries91315263gentries
gingelies11277503gingelies
grinderies1245833grinderies
gunneries1047043gunneries
henneries1248643henneries
henries102718283hen_ries
hinnies103615103hin_nies
indies73822783_in_dies
indris7311963_indri_s
inertias8410383_inertias
inerts64517023_iner_ts
inheres10315173_inher_es
inherits11310103_inherits
injuries1567683_injuries
innerves1158013innerves
interims101013073_interims
internes82721233_internes
interties9320333_interties
inures63318953_inur_es
inverses112410983_inverses
ivories10310713_ivories
japeries17311463japeries
kineses113111253kine_ses
kinesics14286283kinesics
kinesis11259593kinesi_s
kinetics14207253kinetics
kinetins12228153kinetins
liberties1149203liberties
lienteries1047563lienteries
liernes739623li_ernes
lindies8416583lin_dies
lineages979183lineages
linearise946433linearise
linearises1046343linearises
linearizes1945733linearizes
linerless936333linerless
liners65428853liner__s
lingerie959203lingerie_
liveried1238733liveried
minerals10311373minerals
miners84126633miner__s
minifies13312903minifies
miniseries1246753miniseries
minnies93617363min_nies
monkeries15129913monkeries
moperies12313873moperies
naperies10313903naperies
nereis6315343__nereis
nerves94216193__nerves
newies91014073__newies
niceties10310863niceties
ninepins1045873ninepins
ninnies73713613nin_nies
niterie7313743niterie_
nunneries947113nunneries
onerier7311613_onerier
oneriest8313443_oneriest
ornerier846043ornerier
orneriest947403orneriest
orreries8310123orreries
panfries13149203panfries
pantries101817393pantries
peeries93623023_peeries
penuries10311663penuries
pierces113411193pi_erces
pieties9419223pi_eties
piggeries13107893piggeries
pinenes93416673pine_nes
pinkies133818263pin_kies
pinnies93318443pin_nies
piperines131610693piperines
poperies12316793poperies
printeries12410633printeries
queries16315873_queries
quinaries1857873quinaries
reveries112518513reveries
rifleries1247683rifleries
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
sceneries1149393sceneries
sentries81318053sentries
series64540973__series
shinneries1345713shinneries
siderites10410433siderites
signories10107853signories
spiceries1349313spiceries
spinneries1245733spinneries
sundries9312023sundries
synergies1345093synergies
tanneries9310423tanneries
tiderips1145383tiderips
tierces93710453ti_erces
tineids8337873tine_ids
turneries948493turneries
unnerves1157273unnerves
urinaries949203urinaries
veeries102916893_veeries
vinifies1439873vinifies
vivaries1439263vivaries
voleries11313233voleries
wienies102213683wi_enies
wiggeries14136573wiggeries
winterier1238333winterier
winteriest1348813winteriest
winterizes2247143winterizes
wintrier1136873wintrier
wintriest1238153wintriest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622617.26620115.9
3Display Results2612610.1062462.3
 (SQL Overall)1786912617.79522923.8
 
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.