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 “bandsaw” 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
bandsaw133480(None) 
bandsaws1444621bandsaws
handsaw1435531handsaw
backsaw1836202backsaw
banda85223102band_a_
bandas95120542band_as
bandeau1038522bandeau
bands85233422bands__
bandsman1346752bandsman
handsaws1545872handsaws
ands57833613_ands__
ansa45927773_an_sa_
ansae55720973_an_sae
babysat14135233babysat
backsaws1946803backsaws
badass949293ba_dass
badman113813843ba_dman
bads77048863ba_ds__
balds85524643balds__
balsa77920413ba_lsa_
balsam105612233ba_lsam
balsas86417523ba_lsas
banal75925993ban__al
banana83213413banana_
bananas93312223bananas
band76740903band___
bandage11311023bandage
bandaid11310483bandaid
bandana10179463bandana
bandanas11178573bandanas
bandbox1943763bandbox
bandeaus1146503bandeaus
bandeaux1843293bandeaux
banded105223173band_ed
bander93928223band_er
banders104324563banders
bandied114414303bandied
bandies104124863bandies
banding114921413banding
bandit93821133band_it
bandito103710043bandito
bandits103814793bandits
bandmate1347973bandmate
bandog1038723band_og
bandogs1138363bandogs
bandora1038813bandora
bandoras1138743bandoras
bandore10611633bandore
bandsmen1356453bandsmen
bandstand1343933bandstand
bandy114824183band__y
banes74945583banes__
bangs85627773bangs__
banian8315383ban_ian
banish111416043banis_h
banjax2234763ban_jax
banks115527903banks__
banksia1335943banksia
banksias1445893banksias
banns75321233banns__
bans66555133ban_s__
bantam10314063ban_tam
banyan1139483ban_yan
banzai1737653ban_zai
bards87139643bards__
basal75722283ba__sal
bashaw14349303ba_shaw
bauds85821043bauds__
bawds116115493bawds__
benday123810813bend_ay
bends85628973bends__
binds86627473binds__
bondman1238043bondman
bonds86126843bonds__
bondsman1345693bondsman
bonsai838463bon_sai
brands95118943brands__
bucksaw1844373bucksaw
bunds85523543bunds__
hacksaw1943713hacksaw
handax1749583hand_ax
handbag1495863handbag
handcar1337373handcar
hands95327383hands__
handsel11308723handsel
handset113016823handset
handsewn1543623handsewn
hansa85416783han_sa_
hansas94616043han_sas
landau7310613land_au
landman1038923landman
lands65426903lands__
landsman1156853landsman
panda85022613pand_a_
pandas95521963pand_as
randan7315253rand_an
rands65930453rands__
sandal73317283sand_al
sandbag11106243sandbag
sandbar10108193sandbar
sanddab1144923sanddab
sandman10310173sandman
sands65228583sands__
sandsoap1143723sandsoap
sansar63613393san_sar
undraw1037813_undraw
vanda94515923vand_a_
vandal103713833vand_al
vandas103915993vand_as
wands96425483wands__
warsaw1236193wa_rsaw

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.1561145455.1
2DLD Change Limit1340271117.64017542.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.84222786.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.