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

104 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
uniface123695(None) 
unifaces1346391unifaces
biface1358102_biface
boniface1543862boniface
enface112510352en_face
unbrace111910482unbrace
unific1137462unific_
unitage838992unitage
unlace82215172un_lace
animacy1446103animacy
animate91617213animate
anlace82513923an_lace
bifaces1448063_bifaces
bonifaces1643733bonifaces
catface1436763catface
cnidae978143cnida_e
deface123113863_deface
dogface1454053dogface
edifice1344933edifice
efface14366673_efface
enfaced13218913en_faced
enfaces122110913en_faces
enlace82213233en_lace
face96140123___face
fullface1642553fullface
grimace1255083grimace
infare9313083in_fare
inlace82513043in_lace
knife1210010133knif__e
nice65534713_ni__ce
nidate7313783_nidate
niece74814503_ni_ece
nuisance1045703nuisance
orifice1246343orifice
outface123011973outface
pinnace113510313pinnace
preface14510923preface
reface113616353_reface
sniffle13287653sniffle
surface1238653surface
tunicae9328143tunica_e
tunicate103310043tunicate
umiac938963umi_ac_
umiack1435173umi_ack
umiacs1035663umi_acs
unawake1445343unawake
unaware1038033unaware
unbale83616403un_bale
unbraced132310433unbraced
unbraces12229413unbraces
unbrake13239123unbrake
uncage93014873un_cage
uncake122813523un_cake
uncase83817433un_case
unciae83215313uncia_e
uncinate10312393uncinate
uncrate9415953uncrate
undefaced1644753undefaced
undrape1049333undrape
unease63816643un_ease
uneffaced1842573uneffaced
unfaded123111733un_faded
unfair936233un_fair
unfaked153211173un_faked
unfancy1545203un_fancy
unfazed20299053un_fazed
unfence1239193unfence
unfree9413203un_free
ungraced12239143ungraced
unicycle15153183unicycle
unifiable1447343unifiable
unified112413573unified
unifier102211863unifier
unifies102714713unifies
uniform1247053uniform
unify113611113unif__y
unique1558163uni_que
unisize1647343unisize
unitages938273unitages
unitard838003unitard
unitary1038613unitary
unite54828383uni__te
unitive10310563unitive
unitize16310033unitize
univalve1443473univalve
unlaced102913733un_laced
unlaces92513623un_laces
unlade72714153un_lade
unmade92911063un_made
unmake122811213un_make
unpack1457833un_pack
unplaced1338613unplaced
unsafe9310693un_safe
unstack1337373unstack
unstate71916213unstate
untack1239763un_tack
untame82513603un_tame
unteach1246143unteach
untraced112413243untraced
untrack1338703untrack
unvoice12126153unvoice
unweave1336363unweave
urinate7315363urinate
vivace1436553_vivace

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271045.93622578.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.37228043.2
 
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.