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

126 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
bailout941413(None) 
bailouts1036611bailouts
backout15612952backout
bailor83412602bailo_r
bailors93212412bailors
ballot84624092ballo_t
fallout10313502fallout
rainout7314392rainout
ablaut8313263_ablaut
about75229083_a_bout
afloat9315153_afloat
allot54933873_allo_t
aloft8423433_a_loft
aloud65018073_a_loud
bacillus1245153bacillus
backouts1698643backouts
badmouth1643583badmouth
bail65042803bail___
bailed94726653bail_ed
bailee84526013bail_ee
bailees93914383bailees
bailer85425253bail_er
bailers94221353bailers
bailey115015673bail_ey
baileys12388933baileys
bailie83818363bail_ie
bailies94120203bailies
bailiff1546073bailiff
bailing103723523bailing
bailment1249183bailment
bails75933523bail__s
bait66556003bai___t
ballast9313993ballast
ballet84733973ba_llet
ballon84117493ballo_n
ballonet10314503ballonet
ballons93916963ballons
balloon93711433balloon
ballots94116033ballots
ballute938543ba_llute
barbut104617003ba_rbut
barlow112911433barlo_w
barlows12259983barlows
basilect1245903basilect
bayou10512363ba_you_
bayous11411153ba_yous
becloud1246293becloud
beshout12311843beshout
bigot84828323b_igo_t
bijou1458793b_ijou_
bijous1548043b_ijous
bijoux2253453b_ijoux
bilious9310933b_ilious
billet86029723b_illet
biont7727163b_i_ont
blackout1647413blackout
bloat75229923b__loat
blot65842323b__lo_t
blowout1248403blowout
boiloff1543783boiloff
bout66353293b___out
brulot8912213brulo_t
bugout9311863b_ugout
buildup1242333buildup
built74325923buil__t
bullous9311663bullous
bullpout1245783bullpout
burgout1049773burgout
burnout9310453burnout
buyout11310103b_uyout
callous93516603callous
campout13412853campout
clout75330463__clout
dimout9414243_dimout
fadeout11410193fadeout
faitour1034883faitour
fallouts1137883fallouts
flout86226203__flout
galiot72322593galio_t
gallnut847253gallnut
galloot82814223galloot
gallous82813953gallous
galoot72719163ga_loot
glout65925813__glout
haircut1246833haircut
halibut1289053halibut
hallot95426783hallo_t
handout11314103handout
hangout11411393hangout
haplont12412563haplont
harlot94422803harlo_t
hayloft1696963hayloft
jailor13418573jailo_r
jailors14328753jailors
layout9513703la_yout
lout45952143___lout
mahout11415813ma_hout
maillot9312173maillot
nailset7311973nailset
pailful1236103pailful
parlour937263parlour
parlous9414293parlous
payout11714653pa_yout
pigout9314613_pigout
pilot77435063_pilo_t
pilous84717753_pilous
pullout9310593pullout
ragout7317183ra_gout
railbus934413railbus
rainouts846923rainouts
rollout7811943rollout
sailboat1047693sailboat
sailor63113753sailo_r
sailors73213723sailors
sellout7313583sellout
slipout949083slipout
spinout9311583spinout
tailcoat1046853tailcoat
tailor63412503tailo_r
tailors73212393tailors
takeout1149873takeout
valour93010373va_lour
wailful1344953wailful
walkout1447933walkout
walnut939433wa_lnut
washout13410133washout

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.406440125.6
2DLD Change Limit1340271266.42320866.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.87525991.4
 
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.