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

153 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
fortify163652(None) 
mortify1536221mortify
certify1546242certify
cornify1536252cornify
forties104323862forties
fortis95418612forti_s
fortuity1465572fortuity
forty114824272fort__y
horrify1635022horrify
notify1236942no_tify
refortify1842832refortify
torrify1335012torrify
acetify1545003acetify
aerify122810113aer_ify
aortic8316613aorti_c
artily92814713_artily
beatify1536593beatify
borty105522833bort__y
brutify1543883brutify
carnify1555883carnify
citify1437443_citify
coalify1536683coalify
codify1537163co_dify
cornily12410853cornily
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
dirtily1138583dirtily
dorty96220813dort__y
dottily1147283dottily
falsify1643613falsify
fancify1834983fancify
farting114120753farting
fattily13379463fattily
ferity122813343fer_ity
fertile10311733fertile
foamily1546543foamily
foetid10510513foeti_d
foggily1535053foggily
fontina1038633fontina
footboy1544913footboy
footie94718143footi_e
footier104115113footier
footies103721543footies
footing115017593footing
footsy12587933foot_sy
footway1635253footway
footy115820533foot__y
foray115023973for__ay
forbid123312433forbi_d
forbids13268263forbids
forby135317673for__by
forcibly1843863forcibly
forcing134013753forcing
fordid113512053fordi_d
fording123717043fording
forebay1538133forebay
foreby1438633for_eby
foreign1136833foreign
foretime1348213foretime
forgery14419303forgery
forging124114723forging
forgive1436193forgive
forint9325023for_int
forkier144311593forkier
forking154014843forking
forklift1843523forklift
forky156119643for__ky
formic13310453formi_c
formica1436443formica
forming133615733forming
fornix1636033forni_x
forrit91916623forri_t
fort76456443fort___
forte86131463fort__e
fortes95327183fort_es
forth116222673fort__h
fortieth1445173fortieth
fortified1646503fortified
fortifier1546253fortifier
fortifies1548693fortifies
fortifying2045153fortifying
forts86034453fort__s
fortune1068303fortune
fortyish1744843fortyish
forwhy1834423for_why
fourthly1742523fourthly
foxily1947253fo_xily
frostily1436693frostily
frothily1745303frothily
frothy15578373frot_hy
fructify1942353fructify
fruity12429693f_ruity
furmity1535183furmity
furrily1337613furrily
furtive1337173furtive
fustily133111373fustily
glorify1444583glor_ify
gorily10612503gor_ily
goutily1137933goutily
gratify1436113gratify
hornily1338283hornily
horsily1338843horsily
jollify2044263jollify
joltily1746323joltily
justify2034663justify
loftily1336353loftily
metrify1535623metrify
modify1537173mo_dify
mollify1555503mollify
mortary12369043mortary
mortice11711493mortice
mortise9713533mortise
motif10519683mo_tif_
motifs1139673mo_tifs
mystify1843563mystify
nitrify1335793nitrify
ossify1244973_ossify
petrify1536573petrify
pontiff1547903pontiff
portico11310143portico
porting103021783porting
portion9615493portion
portly114713403port_ly
portray1237483portray
purify14399153pur_ify
rarify123210063rar_ify
ratify122610043_ratify
rectify1536453rectify
reify114814973__reify
scorify1535203scor_ify
sootily101810523sootily
sorrily1039833sorrily
sortie63621993sorti_e
sortied83314103sortied
sorties74126403sorties
sorting83221813sorting
sportif1238803sportif_
sportily1337733sportily
stratify1445703stratify
tartily103511573tartily
terrify1336353terrify
testify13246943testify
torrefy1353353torrefy
tortile7313193tortile
verbify1834993verbify
verify153110163ver_ify
versify1636333versify
vitrify1645003vitrify
wordily1437853wordily
worthily1745253worthily
worthy15598803wort_hy
zombify2642253zombify

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.406440125.6
2DLD Change Limit1340271537.28018410.3
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.74923059.9
 
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.