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

177 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
ratifier113967(None) 
gratifier1345821gratifier
ratified12310501ratified
ratifiers1236451ratifiers
ratifies11313511ratifies
artificer1444022artificer
basifier1337312basifier
gasifier1236272gasifier
gratified1446252gratified
gratifiers1443862gratifiers
gratifies1347992gratifies
notifier1137422notifier
pacifier1557502pacifier
rainier71614262ra_inier
ramified1438042ramified
ramifies13310502ramifies
rarefier1135352rarefier
rarified1239052rarified
rarifies11311942rarifies
rattier74015592rat_tier
rectifier1457732rectifier
reifier103414522r_eifier
rotifer1036992rotif_er
satisfier1243732satisfier
acetifier1444863acetifier
airier64619363_a_irier
argufier1242113argufier
artier63419733art__ier
artifice1346403artifice
artificers1543503artificers
artifices1446483artifices
artsier768943art_sier
atelier7311643_atelier
basified1437823basified
basifiers1445203basifiers
basifies13310493basifies
battier93515723bat_tier
beatified1577863beatified
beatifies1459283beatifies
beautifier1543483beautifier
brainier102510233bra_inier
brattier1047663brat_tier
brutified1544773brutified
brutifies1445713brutifies
catbrier1236183catbrier
catchier15329863catchier
cattier93317073cat_tier
certifier1447353certifier
citified1438253citified
citifies13310683citifies
clarifier1446123clarifier
codifier1447163codifier
crucifier1644313crucifier
daffier1457833da_ffier
deifier113013123_deifier
draffier1574323dra_ffier
edifier11309263_edifier
falsifier1544433falsifier
fattier103513463fat_tier
fortifier1546253fortifier
gasified1336533gasified
gasifiers1344523gasifiers
gasifies1238693gasifies
grainier9218903gra_inier
hairier103111053ha_irier
justifier1944363justifier
lathier10310833lat_hier
laticifer1443743laticifer
magnifier1545273magnifier
matier84321523mat__ier
modifier1446703modifier
mortifier1446923mortifier
mystifier1744363mystifier
nattier73614623nat_tier
nazified2144993nazified
nazifies2036063nazifies
nitrifier1245963nitrifier
notified1238363notified
notifiers1245023notifiers
notifies11310423notifies
opacifier1643623opacifier
ossifier111196273ossifier
pacified1638363pacified
pacifiers1645473pacifiers
pacifies15311233pacifies
patchier15319673patchier
patissier1143193patissier
petrifier1447123petrifier
prettifier1543973prettifier
purifier1338573purifier
qualifier2145123qualifier
quantifier2243643quantifier
racier85120973ra__cier
raffler13339223ra_ffler
rafter94517583ra__fter
raider74318743ra_i_der
railer64524933ra_i_ler
raiser66620103ra_i_ser
rallier73816283ra_llier
ramilie9310283ramilie_
ramilies10311833ramilies
rammier112811023ra_mmier
randier83618473ra_ndier
rangier83714353ra_ngier
rapider1067903rapi_der
rapier84019993ra__pier
rarefied1245913rarefied
rarefiers1244023rarefiers
rarefies1138993rarefies
rarities8316333rarities
raspier93110643ra_spier
ratafee1047523rataf_ee
ratafees1144143ratafees
ratafia1045773ratafi_a
ratafias1145323ratafias
ratanies8312923ratanies
rater54943283rat___er
ratfink1434943rat_fink
ratfish1338773rat_fish
rather94319743rat__her
raticide1148943raticide
raticides1248693raticides
ratify122610043ratif__y
ratifying1656823ratifying
ratine65131823rati_ne_
ratines75328583rati_nes
rationed9410093rationed
ratite65022423rati_te_
ratites74920683rati_tes
ratooner887003ratooner
rattener8238533rattener
ratter64326313rat__ter
rattler74012743rat_tler
ravisher1465463ravisher
rectified1539253rectified
rectifiers1545173rectifiers
rectifies14310813rectifies
reefier102912553r_eefier
reified112913783r_eified
reifiers11309843r_eifiers
reifies104218283r_eifies
retirer74715013reti_rer
ribier84414233r__ibier
rifer84721983r__if_er
rifler94014263r__ifler
rimier83916273r__imier
ritzier16297203rit_zier
roilier7311523r_oilier
rotifers1136043rotif_ers
roturier836033roturier
ruttier73412283rut_tier
salified12310363salified
salifies11314793salifies
sanctifier1553493sanctifier
satirizer1846463satirizer
satisfied1343873satisfied
satisfiers1342713satisfiers
satisfies1245323satisfies
scarifier1446653scarifier
stiffer13319393_stiffer
stifler102911473_stifler
stratified1445173stratified
stratifies1346743stratifies
tackifier1844143tackifier
tattier74216243tat_tier
testifier12116893testifier
tidier73515113__tidier
tinier63622233__tinier
typifier1643403typifier
uglifier1244503uglifier
unifier102211863_unifier
untidier946783untidier
verifier14159203verifier
vilifier1456693vilifier
vivifier1745173vivifier
waterier11312103waterier
wrathier1435903wrat_hier

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.423422437.4
2DLD Change Limit1461621777.34319904.9
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.84222786.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.