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

106 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
cavitied1412681(None) 
cavities131412611cavities
calvities1438932calvities
canities101519252canities
caviled1348722cavi_led
cavilled1436732cavilled
cavitated15177352cavitated
citied94014142c__itied
vanitied12138212vanitied
acuities10312453acuities
alibied1038143_alibied
amities9317383_amities
aviated11310263_aviated
baited95319243ba_it_ed
basified1437823basified
cabined1239993cabi_ned
caddied123710563ca_ddied
cairned1037643ca_irned
caitiff1547133ca_itiff
calcified1746893calcified
calibred1335053calibred
candied113816023ca_ndied
canopied1336333canopied
canted94825783ca_nt_ed
capitated14159043capitated
caried94528693ca__ried
carnified1547293carnified
carotid102014823caroti_d
carried103717153ca_rried
carted98631443ca_rt_ed
casefied1445943casefied
castled104311513ca_stled
catted95422473ca__tted
cattie85221023ca_ttie_
cattier93317073ca_ttier
catties94023053ca_tties
cavalier1348173cavalier
cavatina1347333cavatina
cavatine13310323cavatine
caveated1439133caveated
caved116227563cav___ed
caverned1436163caverned
caviare1238373caviare_
caviares1337993caviares
cavie104621593cav__ie_
cavies114525003cav__ies
caviler1249063cavi_ler
caviling14310113caviling
caviller1337063caviller
cavitary1664963cavitary
cavitate13159833cavitate
cavitates14168963cavitates
cavity14310013cavit__y
cavorted1435693cavorted
cecities12312043cecities
charities14312743charities
chivied16368383c_hivied
chivvied2052523chivvied
cited84421953c__it_ed
cities84524853c__ities
citified1438253citified
civilised1584603civilised
civilized24105483civilized
clarified1546973clarified
clarities11312483clarities
coalified1546813coalified
codified1537403codified
comities12317793comities
covaried1448003covaried
coveted133011523covet_ed
daisied93410013da_isied
evited104013143_evit_ed
faithed1437163fa_ithed
gaited84416923ga_it_ed
gasified1336533gasified
gavotted1363343gavotted
gravities1338303gravities
habited1337883habit_ed
invited113612463invit_ed
laities7320343la_ities
lavished1555133lavished
laxities1539093laxities
levities11310713levities
nazified2144993nazified
pacified1638363pacified
parities10522973parities
partied103516553pa_rtied
pitied94017253__pitied
ramified1438043ramified
rarified1239053rarified
rarities8316333rarities
ratified12310503ratified
ravined115411823ravi_ned
ravished1555713ravished
safetied1244663safetied
salified12310363salified
sanities81219763sanities
sanitised10147353sanitised
sanitized19138173sanitized
savvied1433803sav_vied
scarified1547293scarified
suavities1248413suavities
unpitied1138793unpitied
vanities111414493vanities
vivified1845893vivified
waited103819773wa_it_ed

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.1561145455.1
2DLD Change Limit1461621067.15620425.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.34224338.2
 
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.