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

111 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
misform143751(None) 
misforms1545891misforms
ausform1245242ausform
biform1368132bi_form
inform11310152_inform
isoform1244962_isoform
misfire12229892misfire
misformed1745242misformed
misinform1643782misinform
missort9314652missort
misterm114314512misterm
misword1338412misword
pisiform1564972pisiform
aciform1446023aciform
aliform1247043aliform
ausforms1343933ausforms
bistort91216523bistort
conform14310463conform
deform1259633_deform
deiform1336703deiform
disarm9310473dis_arm
disciform1744133disciform
discord1139993discord
disinform1544123disinform
disport101015953disport
distort81120333distort
ensiform1344363ensiform
filiform1644783filiform
fishworm1943803fishworm
form95836873___form
fusiform1643993fusiform
gasiform1444313gasiform
history1339423history
infirm1137043_infirm
informs1248073_informs
isoforms1344343_isoforms
lissom837403lisso_m
microform1846503microform
microhm1646123microhm
midstory1445103midstory
midterm12316013midterm
milfoil1264383milfoil
milord999573mi_lord
minor74920063mi_nor_
minors85117103mi_nors
mirror848003mirror_
mirrors938623mirrors
misaim10311853mis_aim
miscode12310413miscode
miscoin11311433miscoin
miscook1546473miscook
miscopy1636663miscopy
misdeem12217873misdeem
misdo85413193misdo__
misdoer1048633misdoer
misdoers1137103misdoers
misdoes10312493misdoes
misdone10310863misdone
miser75430403mis_er_
misers85025703mis_ers
misery114113543mis_ery
misfed124113023misf_ed
misfeed13389683misfeed
misfile122611553misfile
misfired14238543misfired
misfires132210583misfires
misfit112813833misf_it
misfits12279663misfits
misfocus1543453misfocus
misforming1845403misforming
misframe1546973misframe
misgrow1344433misgrow
misinforms1752643misinforms
misjoin1637693misjoin
mismark1536703mismark
mismove1437083mismove
miso67229913mis_o__
misos76523293mis_o_s
mispart111113783mispart
missorts1038323missorts
missout9412663missout
mister84728563mister_
misterms123711353misterms
misters93927513misters
mistook1337153mistook
miswords1446603miswords
misyoke1635823misyoke
omniform1544013omniform
oviform1544823oviform
perform1439293perform
piciform1765003piciform
piefort1249543piefort
piliform1555483piliform
pinworm1467183pinworm
piriform1555763piriform
pisciform1843263pisciform
pisiforms1643503pisiforms
postform1556223postform
preform1439623preform
ramiform1544713rami_form
reform11312723_reform
reinform1346203reinform
slipform1543583slipform
storm76520403__storm
triform1237863triform
uniform1247063uniform
ursiform1343763ursiform
vasiform1644243vasiform
visor82512833vis_or_
visors92912223vis_ors
wisdom1235983wisdo_m

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 Limit1340271118.36016031.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.81220278.1
 
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.