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 “chints” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
chints11511783(None) 
chants115020391chants
chinas115119381chinas
chines115029171chines
chinks155817571chinks
chinos115018691chinos
chins105631461chin_s
chintz204212021chintz
chits105424571chi_ts
hints87330621_hints
bints76130182_bints
cains75334302cain_s
cants77036942c_ants
cents74730332c_ents
chaines124518732chaines
chains114819702chain_s
changs125215372changs
chant105932692chant_
chanty145215822chanty
charts115823092charts
chats105730092ch_ats
chaunts1267082chaunts
cheats114519542cheats
cherts115617232cherts
chests114916262chests
chianti1236602chianti
chiantis1346582chiantis
chias104625512chi_as
chiaus113611302chiaus
chicas135916462chicas
chicks175317592chicks
chicos134614832chicos
chics123920942chi_cs
chides124620472chides
chiefs14509652chiefs
chiels115115932chiels
chiles115425302chiles
chilis115517872chilis
chills114717702chills
chimbs153910302chimbs
chimes134922572chimes
chimps155713662chimps
chin96934742chin__
china105022472chin_a
chinch163911222chinch
chine105231722chin_e
chined125620062chined
chink145321592chin_k
chinky185610542chinky
chino105823312chin_o
chintses1337112chintses
chintzes2235962chintzes
chintzy24364212chintzy
chips125721252chi_ps
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirrs114514982chirrs
chirus114615692chirus
chis95933312chi__s
chit96937462chi_t_
chitty14329432chitty
chives144317592chives
chotts113610982chotts
chunks154210332chunks
cines75239682c_ines
cists76624532c_ists
clients938092clients
clifts11519152clifts
clines84926042clines
clings95716212clings
clinks125815062clinks
coins75834552coin_s
counts84618272counts
crits75527572cri_ts
cunts76125122c_unts
dints67431312_dints
echinus1236202echinus
elints65816422elints
faints94818782faints
feints94813872feints
flints95617452flints
glints75714212glints
haints94417582haints
hants86335402_hants
hents87330742_hents
hilts86924412_hilts
hinds96721472_hinds
hins76447992_hin_s
hint77455742_hint_
hists86328372_hists
hits75545132_hi_ts
hunts86826172_hunts
joints133811452joints
lints57137192_lints
mints76834042_mints
paints85921832paints
pints75936222_pints
points85618532points
prints84320102prints
quints154316562quints
rhinos94411122rhinos
saints65122422saints
schists1248542schists
shifts124412932shifts
shines95028912shines
shins85131042shin_s
shirts94918332shirts
shists96515102shists
shits84731162shi_ts
shunts95712012shunts
stints65119762stints
suints64617782suints
taints64520532taints
things104914282things
thinks134613352thinks
thins85826322thin_s
tints56030922_tints
whines125120102whines
whins114922332whin_s
whists124613812whists
whits115923822whi_ts

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit825511232.72030349.6
3Display Results1231230.0462673.9
 (SQL Overall)1786911232.87262218.3
 
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.