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

71 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
pontiff154790(None) 
pontiffs1643141pontiffs
goniff13408892gon_iff
pontifex2043252pontifex
pontific1545562pontific
pontil8315462ponti_l
pontils9312212pontils
pontine92419052pontine
caitiff1547133caitiff
fontina1038633fontina
fortify1636523fortify
gonif94320923gon_i_f
goniffs14473903gon_iffs
gonifs104310133gon_ifs
mastiff1538163mastiff
mortify1536223mortify
motif10519673mo_ti_f
motifs1139673mo_tifs
nonlife1038553nonlife
nontariff1545063nontariff
notify1236943no_tify
ontic74418573_onti_c
pantie84326473panti_e
panties94230933panties
pantile93918483pantile
panting104025423panting
plaintiff1742663plaintiff
poetic10416843poeti_c
poetics11312073poetics
poetise9314043poetise
poetize18310773poetize
pointier1038303pointier
pointing112813683pointing
poncing122913583poncing
ponding114317083ponding
pongid104111583pongi_d
pongids11347413pongids
ponging113416153ponging
ponied94920703pon_ied
ponies84833463pon_ies
pontes83627853pont_es
ponton83217643pont_on
pontons93315553pontons
pontoon93010703pontoon
ponying133312123ponying
portico11310143portico
porting103021783porting
portion9615493portion
postfix1944673postfix
postie84123963posti_e
posties93128813posties
postin83521033posti_n
posting105622243posting
postins93721203postins
potion84519573po_tion
pottier93516493pottier
potties93723543potties
potting103720893potting
pouff135215423po__uff
poutier93215323poutier
poutine93316823poutine
pouting103519943pouting
punties94520783punties
punting103318443punting
putoff1436423p_utoff
sniff113915863_sn_iff
sportif1238793sporti_f
stiff114219243__stiff
tiff104727723___tiff
tontine72316143tontine
wonting113214103wonting

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 Filter1786911340270.1731032896.0
2DLD Change Limit134027716.96619240.2
3Display Results71710.0164437.5
 (SQL Overall)178691717.15524974.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.