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

92 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
unifaces134639(None) 
uniface1236951uniface_
bifaces1448062_bifaces
bonifaces1643732bonifaces
enfaces122110912en_faces
unbraces12229412unbraces
unifies102714712unif_ies
unitages938272unitages
unlaces92513622un_laces
animacies1348593animacies
animates101316423animates
anlaces92313733an_laces
biface1358103_biface_
boniface1543863boniface_
catfaces1536963catfaces
defaces133213403_defaces
dogfaces1554143dogfaces
edifices1454863edifices
effaces15277273_effaces
enface112510353en_face_
enfaced13218913en_faced
enlaces92313393en_laces
faces106439433___faces
fullfaces1742633fullfaces
grimaces1355383grimaces
infares10313023in_fares
inlaces92512903in_laces
knifes136210213knif__es
nidates8311893_nidates
nieces84112713_ni_eces
nifties102612503_nifties
nuisances1145333nuisances
orifices1346483orifices
outfaces132311393outfaces
pinnaces12268863pinnaces
prefaces15311063prefaces
refaces123216743_refaces
sniffles14257723sniffles
surfaces1338673surfaces
tunicates11268743tunicates
umiacks1534013umi_acks
umiacs1035663umi_ac_s
unawares1137053unawares
unbales92914863un_bales
unbrace111910483unbrace_
unbraced132310433unbraced
unbrakes14258413unbrakes
uncages103213773un_cages
uncakes133012743un_cakes
uncases93516553un_cases
uncrates10314563uncrates
undefaced1644753undefaced
undrapes1138603undrapes
uneases73316263un_eases
uneffaced1842573uneffaced
unfaded123111733un_faded
unfaked153211173un_faked
unfazed20299053un_fazed
unfences1337933unfences
unfixes17238113un_fixes
unfrees1048643un_frees
ungraced12239143ungraced
unicycles16143263unicycles
unific1137463unific__
unified112413573unif_ied
unifier102211863unif_ier
unifiers11237173unifiers
uniforms1355043uniforms
uniques1667443uni_ques
unisexes1554613unisexes
unitage838993unitage_
unitards945623unitards
unites65024853uni__tes
unities72520153uni_ties
unitizes1739133unitizes
univalves1543393univalves
unlace82215173un_lace_
unlaced102913733un_laced
unlades82612833un_lades
unmakes132810793un_makes
unpacks1576093un_packs
unplaced1338613unplaced
unstacks1446043unstacks
unstates81314993unstates
untacks1357503un_tacks
unteaches1446083unteaches
untraced112413243untraced
untracks1437523untracks
unvoices13125163unvoices
unweaves1436143unweaves
urinates8314133urinates
vivaces1536413_vivaces

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.1531167915.0
2DLD Change Limit146162927.51619446.8
3Display Results92920.0303066.7
 (SQL Overall)178691927.69923209.6
 
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.