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

89 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
pacific164691(None) 
acidic113612132_acidic
acinic104713542_acinic
calcific1445022calcific
pacifical1845232pacifical
pacified1638362pacified
pacifier1557502pacifier
pacifies15311222pacifies
pacifism1746372pacifism
pacifist1548092pacifist
pacify1667472pacif_y
specific1744702specific
acetic10314503_acetic
acini75718983_acini_
aclinic11188973_aclinic
acmic11312333_ac_mic
actinic111810553_actinic
adipic1137263_adipic
amidic114012873_amidic
aminic104413513_aminic
anisic8313793_anisic
aplitic11311743aplitic
ascitic1139323ascitic
bacchic1545813bacchic
backfit18108213backfit
basilic1137493basilic
beatific1544223beatific
calcitic1148193calcitic
civic123412543__civic
deific1237313_deific
diacidic1444063diacidic
fanfic1436313fa_nfic
fatidic1345723fatidic
jaditic1746703jaditic
laconic1139883laconic
lactic10713493lac_tic
mafic125615463ma__fic
magnific1654213magnific
malefic1486323malefic
motific1446323motific
omnific1443813omnific
opacified1744393opacified
opacifier1643623opacifier
opacifies1645463opacifies
opacify1743653opacif_y
ossific1243103ossific
pachalic1757273pachalic
pachisi14329523pachisi_
pachisis15268823pachisis
pacier105018683paci_er
paciest112917813paciest
pacificism2152663pacificism
pacificist1953693pacificist
pacifiers1645463pacifiers
pacifisms1845093pacifisms
pacifistic1953823pacifistic
pacifists1645063pacifists
pacifying2045503pacifying
pacing114522753paci_ng
panic93923903pa__nic
panini8314273panini_
papistic1448733papistic
paretic113016673paretic
parodic122311723parodic
parotic112518043parotic
pectic122913873pec_tic
pelitic111814653pelitic
picnic123410263pic_nic
picric12309923pic_ric
picritic1448263picritic
platinic1237073platinic
poditic122611583poditic
politic112918713politic
pontific1545563pontific
practic13312253prac_tic
prolific1546743prolific
pyridic15267833pyridic
pyritic143311313pyritic
racemic1336983racemic
rachitic1547593rachitic
sacrifice16134533sacrifice
salvific1643293salvific
satiric939253satiric
specifics1843933specifics
tactic10612753tac_tic
taxitic1637093taxitic
unacidic1343433unacidic
unific1137463_unific
vivific1843363vivific

Search took 10 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.406440125.6
2DLD Change Limit134027899.37314299.3
3Display Results89890.0302966.7
 (SQL Overall)178691899.80918217.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.