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

112 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
botanise103964(None) 
botanies10312851botanies
botanised1246391botanised
botanises1139161botanises
botanist10412031botanist
botanize1948751botanize
botanic1159582botani_c
botanica1295722botanica
botanists1148202botanists
botanized2147282botanized
botanizer2046242botanizer
botanizes2048422botanizes
romanise10312132romanise
tetanise8610202tetanise
totalise8312502totalise
womanise1348732womanise
anise55129703___anise
banish111416043b__anish
beanie83618593b_eani_e
beanies93821093b_eanies
betaine9413783beta_ine
betaines10313293betaines
betise85616273bet__ise
betonies10413063betonies
boarish123911913bo_arish
boatlike1457963boatlike
bogans95714813bogan_s_
bonacis11310323bonacis_
bonnie85314853bo_nni_e
boonies93422483bo_onies
boracite1249193boracite
borane84620213boran__e
boranes93720403boranes_
bornite9311183bo_rnite
botanical1366073botanical
botanicas1365253botanicas
botanising1345953botanising
botanizers2144283botanizers
botany1139263botan__y
botas75328783bota__s_
botflies1336733botflies
bothies12414783bot_hies
botonee9311833boton_ee
botonnee1044693botonnee
botryose1342893botryose
botulism1246473botulism
boyarism1546393boyarism
braise84318753b_ra_ise
brutalise1175693brutalise
butane8313653butan__e
butanes9312743butanes_
butanone1044963butanone
cognise1059683co_gnise
colonise102514283colonise
cotans81317923cotan_s_
cotinine10311493cotinine
cutinise1048763cutinise
ebonise939613ebo__nise
focalise131210373focalise
humanise1348513humanise
ionise63516943io__nise
iotacism1246893iotacism
kyanise14236143_kyanise
litanies8310993litanies
localise101511853localise
lutanist8410273lutanist
metalise10416053metalise
moralise10314913moralise
motorise10311523motorise
notaries8314933notaries
notarize1749293notarize
obtains939163obtains_
onanism9310133_onanism
onanist7314633_onanist
organise939323organise
ozonise1646443_ozonise
paganise1139663paganise
polarise10513903polarise
ratanies8312923ratanies
romanised1247923romanised
romanises11311573romanises
romanize19311013romanize
rotaries8315693rotaries
rotative11310343rotative
satanism1039673satanism
satanist8313363satanist
solanine8311533solanine
solarise8512543solarise
stanine73417073_stanine
tanist6324593__tanist
tetanies8513553tetanies
tetanised1096513tetanised
tetanises979873tetanises
tetanize17109953tetanize
titanism1048213titanism
titanite898433titanite
totalised1048073totalised
totalises9311783totalises
totalism10311093totalism
totalist8315583totalist
totalize17311523totalize
urbanise10107283urbanise
vitalise11310743vitalise
vocalise131510813vocalise
votaries11312013votaries
votarist111012163votarist
womanised1545753womanised
womanises1448063womanises
womanish1646823womanish
womanism1548113womanism
womanist13410433womanist
womanize2248163womanize

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 Limit1461621126.95321021.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.42224075.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.