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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
parfaits134691(None) 
parfait12312051parfait_
affairs1334163_affairs
afrits9311903_a_frits
arhats9312973_arha_ts
armpits1157133_armpits
awaits96411953_a_waits
barflies1338303barflies
bargains1178643bargains
barmaids1345943barmaids
carats85929023car_a_ts
carfares13310323carfares
farfals13268503farfa_ls
forfeits1445803forfeits
haffits1636193ha_ffits
karats106420493kar_a_ts
kraits104912203_kr_aits
lariats7615053laria_ts
pageants1136693pageants
palais8420423pa_lai_s
pandits103914213pa_ndits
panfries13149203panfries
papains11312363pa_pains
parades104121463par_ades
parados103816053par_ados
paraffins1744643paraffins
parafoils1445503parafoils
parakite14410423parakite
parakites1549543parakites
paramos113213513par_amos
parangs104314373par_angs
parapets1239763parapets
paraphs1439313par_aphs
paras76143043par_a__s
parasails1147583parasails
parasite10314843parasite
parasites11313153parasites
parbakes1638343parbakes
parboils1237433parboils
pardahs13289673parda_hs
parents93418123par_ents
paresis93315093paresi_s
paretics122312443paretics
pargets105215193par_gets
pariahs123812343paria_hs
parians93519733paria_ns
paries84742513par__ies
paris75145943par__i_s
parities10522973parities
parity114719873par__ity
parkades1538273parkades
parkas125018023parka__s
parlante1039693parlante
parlays123910453parla_ys
parodies11313693parodies
parodist11412763parodist
parodists1248513parodists
parotids112610413parotids
parotitis1149173parotitis
parquets1936413parquets
parrals94414573parra_ls
parries93925843par_ries
parrots9312743par_rots
parsnips1245533parsnips
partakes1449923partakes
partans94418283parta_ns
partials101911963partials
parties93230863par_ties
partita9310863par_tita
partitas10310253par_titas
partite9317133par_tite
partlets102811513partlets
parts77743373par___ts
parvis116114803par_vi_s
pearmains1345263pearmains
perfects15107353perfects
periapts1237273periapts
permits11314003per_mits
persalts1038193persalts
pertains102113423pertains
plaits83816473p__laits
portraits1146803portraits
prats76333393p_r_a_ts
preacts113211363p_reacts
probits112712573p_robits
profits122911243p_rofits
pursuits1045043pursuits
rarebits1045223rarebits
straits74916323str_aits
surfeits1146223surfeits
traits65121983_tr_aits
variants1139203variants
warfares1436683warfares
warfarins1544733warfarins
warrants1168503warrants

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.420425454.8
2DLD Change Limit146162956.72021750.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.17024922.0
 
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.