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

137 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
fixities183822(None) 
dimities11314002dimities
ferities111416722ferities
fifties132111082fi_fties
finites10315922finit_es
fixates1737392fixat_es
fixatifs2162072fixatifs
fixatives2243352fixatives
laxities1539092laxities
sixties14310972six_ties
abilities11714143abilities
acidities12810183acidities
acuities10312453acuities
affinities1645713affinities
agilities10810973agilities
aminities11312913aminities
amities9317383_amities
anilities9516003anilities
anxieties1646263anxieties
aridities10911633aridities
avidities13107613avidities
axites134913833_axit_es
bifidities1644453bifidities
canities101519263canities
cavities131412613cavities
cecities12312043cecities
cities84524853__cities
citifies13310683citifies
comities12317793comities
coxitides1945113coxitides
coxitis16238463coxiti_s
deities82621923_deities
digitizes2046923digitizes
dignities1149593dignities
dirties83119383di_rties
ditties83116983di_tties
dixits144210313dixit__s
eighties12710803eighties
enmities10611353enmities
entities8617413entities
equities17310773equities
facilities1549823facilities
fairies103516043f_airies
falsities1248133falsities
families1339443families
fatties103018203f_atties
fatuities1246913fatuities
fealties1139993fealties
felicities1549743felicities
felinities1349443felinities
feminities1549683feminities
fetidities1447873fetidities
fidelities1445933fidelities
filiates11412663filiates
filicides1545953filicides
fillies103420253fi_llies
finalities1349913finalities
fineries112416753fineries
finises10312903fini_ses
finishes1438983finishes
finite9316823finit_e_
finitudes1344313finitudes
fixate1638733fixat_e_
fixated1835533fixat_ed
fixatif2054633fixati_f
fixating1936183fixating
fixation1837073fixation
fixations1936353fixations
fixative2145083fixative
fixes154723593fix___es
fixings18347443fixi_ngs
fixit154819303fixit___
fixity19427813fixit__y
fixtures1835283fixtures
fixures17596063fix_ures
flexitimes2242153flexitimes
flites95122443f_lit_es
fluidities1445223fluidities
fomites123613203fomit_es
footies103721543f_ooties
forties104323863f_orties
frailties1245853frailties
frites94922483f_rit_es
fritzes19329453f_ritzes
fruitier1136593fruitier
fruitiest1237383fruitiest
fugitives1643543fugitives
furmities1447543furmities
futilities1348863futilities
infinities1369453infinities
iritis63113733_iriti_s
iritises839983_iritises
ixtles13217063_ix_tles
kibitzes2342863kibitzes
kilties113014143ki_lties
kitties113213623ki_tties
laities7320343_laities
lenities8315943lenities
levities11310713levities
limites92915453limit_es
militias1048633militias
minifies13312903minifies
niceties10310863niceties
nidifies1238233nidifies
nifties102612503ni_fties
nighties121011383nighties
nimieties1145233nimieties
nineties8312923nineties
nixies135313873nix__ies
nudities939683nudities
oddities1046603oddities
parities10522983parities
pieties9419223pi_eties
pigsties1139783pigsties
pinites9319533pinit_es
piosities11311723piosities
pities83828083__pities
pixies154915513pix__ies
polities102722343polities
privities14312043privities
purities10316283purities
rarities8316333rarities
righties12711573righties
sanities81219773sanities
sixtes133612403six_t_es
taxites1449673taxit_es
titties73617363ti_tties
trinities9313353trinities
unities72520153_unities
utilities9610803utilities
vanities111414493vanities
verities111418043verities
viduities1346113viduities
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
whities133113253_whities

Search took 9 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.453394461.4
2DLD Change Limit1461621378.37617450.1
3Display Results1371370.0602283.3
 (SQL Overall)1786911378.88920102.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.