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

161 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
bistort9121652(None) 
bistorts10118811bistorts
distort81120331distort
bister84922762bister_
bisters93922612bisters
bistoury1343412bistoury
bistre83815022bist_re
bistro8339942bist_ro
bistros92810982bistros
disport101015952disport
distorts91112352distorts
history1339422history
intort6418922_intort
missort9314652missort
airport9511383airport
assort64916383_assort
bastard103012423bastard
baster85333593baster_
basters94930303basters
beshout12311833beshout
besot76429713bes_o_t
bestir8311163bestir_
bestirs9311133bestirs
bestow1149463besto_w
bestows1248863bestows
bestrow1237243bestrow
bettor83612223bettor_
bettors93312473bettors
bicorn103610103bi_corn
biform1368123bi_form
bigfoot1355993bigfoot
bighorn1346063bighorn
bigot84828323bi_go_t
bigotry1344523bigotry
biltong1034683biltong
biont7727163bi__ont
biotope1146623biotope
biotron937293biotron
birthwort1754203birthwort
biscotti1243333biscotti
biscotto1242813biscotto
biscuit1147373biscuit
bisect10312873bis_ect
bisector1245193bisector_
bisectors1345733bisectors
bishop1336943bisho_p
bishops1437033bishops
bison75716983bis_o_n
bisons83914373bis_ons
bistate9313823bistate
bistered112913323bistered
bistred103311853bistred
bistres94017213bistres
bistroic1246383bistroic
biter75030033bi_ter_
biters83925243bi_ters
bitstock1643333bitstock
bitt65545813bi_t__t
bitter84622673bitter_
bittern94810683bittern
bitters94920363bitters
bittock1544433bittock
blister94415313blister_
blisters104015083blisters
blistery13418713blistery
bort65960963b___ort
boston8513043bosto_n
bostons9312903bostons
bristol937043bristo_l
bristols1046773bristols
bustard10389723bustard
buster84726493buster_
busters94724133busters
castor84418533castor_
castors94919443castors
cistern93310703cistern
cistron9299883cistron
contort91422343contort
discord1139993discord
dispart101115283dispart
disports111111113disports
disroot8413563disroot
dissert83720693dissert
distant83519953distant
distent84120853distent
distome10313233distome
distorted1139373distorted
distorter1048403distorter
disturb1046233disturb
escort84616483_escort
extort13513973_extort
figwort1448223figwort
gosport101010283gosport
histoid1139823histoid
histone10312843histone
historic1388943historic
import102713763_import
intorts7310973_intorts
lictor83610853lictor_
lictors93212593lictors
lister64527253lister_
listers74026533listers
midstory1445103midstory
misform1437513misform
mispart111113783mispart
missorts1038323missorts
missout9412663missout
misstart10410043misstart
mister84728563mister_
misterm114314513misterm
misters93927513misters
mistook1337153mistook
misword1338413misword
nestor63713423nestor_
nestors73614973nestors
pastor84817483pastor_
pastors94119003pastors
piefort1249533piefort
pistol83313333pisto_l
pistole92414313pistole
pistols93213983pistols
piston83515923pisto_n
pistons93016373pistons
pistou83211843pisto_u
pistous92714383pistous
resort65728623res_ort
restart7320033restart
restore75822983restore
retort66831153_retort
ribwort1249003ribwort
ristra6310713rist_ra
short85040533__short
sister64421583sister_
sisters73721593sisters
sistra639333sist_ra
skort94925643__skort
snort54833753__snort
sort46264813__s_ort
sport75935983__sport
start55642313__start
stoat57135953__stoat
stopt76528353__stopt
store56333813__store
stork96819693__stork
storm76520403__storm
story86723033__story
stot46347333__sto_t
stott56929793__stott
stout57434053__stout
sturt56028963__sturt
tort46967463___tort
upstart9159753upstart
viator93211833viator_
viators102712023viators
victor113210673victor_
victors123311183victors
victory15326983victory
visitor1046203visitor_
visitors1146433visitors
visor82512833vis_or_
visors92912223vis_ors

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271616.00022337.8
3Display Results1611610.0632555.6
 (SQL Overall)1786911616.46627635.5
 
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.