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

105 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
botanises113916(None) 
botanies10312851botani_es
botanise1039641botanise_
botanised1246391botanised
botanists1148201botanists
botanizes2048421botanizes
botanicas1365252botanicas
botanist10412032botanis_t
botanize1948752botanize_
botanized2147282botanized
botanizer2046242botanizer
botanizers2144282botanizers
romanises11311572romanises
tetanises979872tetanises
totalises9311782totalises
womanises1448062womanises
anises64826693___anises
banishes131812463b__anishes
beanies93821093b_eani_es
betaines10313293beta_ines
betises94816123bet__ises
betonies10413063betoni_es
bolases93315003bola__ses
bonuses94212953bo__nuses
boonies93422483bo_oni_es
boracites1347953boracites
boranes93720403boran__es
bornites10310983bo_rnites
botanic1159583botani__c
botanica1295723botani_ca
botanical1366073botanical
botanicals1493163botanicals
botanising1345953botanising
botflies1336733botfli_es
bothies12414783bot_hi_es
botrytises1551643botrytises
botulisms1345303botulisms
boyarisms1645443boyarisms
braises93818873b_ra_ises
brutalises1265083brutalises
bubalises1346323bubalises
butanes9312743butan__es
butanones1144713butanones
cognises11610043co_gnises
colonises112814013colonises
cotinines11410073cotinines
cutinises1148513cutinises
ebonises1039223ebo__nises
focalises14139953focalises
humanises1448313humanises
ionises72916433io__nises
iotacisms1346103iotacisms
kyanises15206393_kyanises
litanies8310993litani_es
localises111411463localises
lutanists966843lutanists
metalises11315073metalises
moralises11314003moralises
motorises11311673motorises
notaries8314933notari_es
notarizes1848713notarizes
onanisms1048063_onanisms
onanists838413_onanists
organises1048683organises
otitises839163_otitises
oxalises1538503_oxalises
ozonises1776373_ozonises
paganises1239723paganises
polarises11514073polarises
ratanies8312923ratani_es
romanise10312133romanise_
romanised1247923romanised
romanizes20310933romanizes
rotaries8315693rotari_es
satanisms1148143satanisms
satanists948233satanists
solanines9310083solanines
solarises9512703solarises
stanines85115673_stanines
tamises92715973__tamises
tanists7313653__tanists
tansies74521243__tansies
tapises92914013__tapises
tetanies8513553tetani_es
tetanise8610203tetanise_
tetanised1096513tetanised
tetanizes1889843tetanizes
tetanuses984613tetanuses
titanisms1147423titanisms
titanites997413titanites
totalise8312503totalise_
totalised1048073totalised
totalisms1139813totalisms
totalists9310753totalists
totalizes18311053totalizes
urbanises11106643urbanises
vitalises12310093vitalises
vocalises141710333vocalises
votaries11312013votari_es
votarists1298603votarists
womanise1348733womanise_
womanised1545753womanised
womanisms1646893womanisms
womanists1446763womanists
womanizes2347993womanizes

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411057.14020818.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.59223536.7
 
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.