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 “ossify” 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
ossify124497(None) 
basify1437512basify
bossily1237562bossily
gasify1336332gasify
gossipy1343952gossipy
ossia53710402ossi_a
ossific1243102ossific
russify1334062russify
aerify122810113aerify
assay8710283ass_ay
assign736783assign
assist6314603assist
assize1538633assize
bossier93712423bossier
bossies94116833bossies
bossing103714603bossing
bossism1136063bossism
bossy105515973boss__y
busily112211503busily
casefy1436273casefy
citify1437443citify
classify1644693classify
coalify1536683coalify
codify1537163codify
cornify1536253cornify
cosily113613853cosily
deify124112763_deify
densify1435293densify
dossier83711693dossier
dossil75110903dossi_l
dossils8669773dossils
dossing93313273dossing
easily9313023easily
edify12308563_edify
essay867623ess_ay
falsify1643613falsify
flossily1434523flossily
fortify1636523fortify
fossick16134733fossick
fossil9379353fossi_l
fossils10379013fossils
fussily13267603fussily
gassily1137813gassily
glossily1235093glossily
gossip946433gossi_p
gossipry1441903gossipry
gossips1035903gossips
horrify1635023horrify
horsily1338843horsily
ignify1334513ignify
jollify2044263jollify
justify2034663justify
lossy85214643loss__y
lousily1038333lousily
massif11412533massif_
massifs1237743massifs
messily12298813messily
minify1439253minify
modify1537173modify
mollify1555503mollify
mortify1536223mortify
mossier94413813mossier
mossing103915423mossing
mossy105217063moss__y
mousily1239393mousily
mussily12279773mussily
mystify1843563mystify
nazify2134233nazify
nidify1336763nidify
noisily1038403noisily
nosily93712683nosily
notify1236943notify
oasis56422553oasi_s
obesity1275653obesity
oddity1135243oddity
oilily93111723oilily
oily77932253o__ily
onside7511803onside
oozily18328073oozily
opacify1743653opacify
opsin7613473opsi_n
opsins8411713opsins
opsonify1642273opsonify
oscine8311563oscine
osier53518013o_sier
osmic939913osmi_c
osmics1036463osmics
osmium1036573osmium
osprey1134883osprey
ossa43714163oss__a
ossein636593ossein
osseins736133osseins
ossicle944483ossicle
ossified1276433ossified
ossifier111196273ossifier
ossifies1177563ossifies
ossifying1644253ossifying
ossuary1043943ossuary
ostia52315583osti_a
ostiary1036463ostiary
ostium8310133ostium
ostomy1137833ostomy
pacify1667473pacify
possibly1544483possibly
purify14399153purify
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
resift94017723resift
resiny94617363resiny
rosily93914713rosily
rosiny94414533rosiny
salify12311373salify
salsify1334703salsify
sassily1038723sassily
seif75638733_seif_
seifs85019333_seifs
shift114225143_shift
shifty15409263_shifty
shily115222013_shily
shiny115122143_shiny
sift710740663__sift
sissy85812073_sissy
sizy164816393__sizy
skiey125012893_skiey
skiff153612803_skiff
slily85820033_slily
slimy105417423_slimy
sniff113915863_sniff
sniffy15337193_sniffy
spicy125417713_spicy
spiff133616403_spiff
spiffy17326223_spiffy
spiky146014113_spiky
spiny104921303_spiny
spiry105017353_spiry
stiff114219243_stiff
stimy105114743_stimy
surfy115319473_surfy
swift116818053_swift
testify13246943testify
torrify1335013torrify
tossing83612563tossing
typify1734523typify
uglify1333913uglify
unify113611113_unify
verify153110163verify
versify1636333versify
vilify1536773vilify
vinify1536923vinify
vivify1834703vivify
zombify2642253zombify

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161535.76619548.4
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.18528891.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.