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 “birle” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
birle7502363(None) 
bible95119421bible
bile66147191bi_le
birl65830481birl_
birled94416991birled
birler85715081birler
birles84920641birles
birls74023161birls
birse74517401birse
aisle55223192aisle
bale66353842b_ale
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barley115116762barley
barre75929552barre
barye105021492barye
belle75827832belle
berme96022942berme
biali73419072biali
bialy105119322bialy
bibles104617642bibles
bice86235572bi_ce
bide76041512bi_de
bield84614652bield
biflex1834952biflex
bigly114814752bigly
bike106532612bi_ke
bikie113915882bikie
biles75542142bi_les
bilge87618912bilge
bilk105824432bi_lk
bill67239952bi_ll
billed94224902billed
biller84923482biller
billet86029722billet
billie85019172billie
bills75632862bills
billy105525362billy
bindle94516262bindle
bine66650872bi_ne
binge85125512binge
biome94916992biome
birch124914022birch
bird76128332bir_d
birded104414302birded
birder94915492birder
birdie94013782birdie
birds85421342birds
bireme10310142bireme
birk106326872bir_k
birkie124110132birkie
birks114920302birks
birlers93813002birlers
biro66131222bir_o
biros75325132biros
birr66022372bir_r
birred94713202birred
birrs74917102birrs
birses84717732birses
birth105619872birth
bise66437112bi_se
bite66547012bi_te
bize155926302bi_ze
bogle85821682bogle
bole66448692b_ole
bore66051332bor_e
borne77926792borne
boule74828042boule
brae65639112b_rae
bree67241262b_ree
bribe94820782bribe
bride86425542bride
bridle94115462bridle
brie65837902b_rie
brill74819952brill
brine75132272brine
bugle84721942bugle
burble104617702burble
burgle94815862burgle
burke115122762burke
burl64937182burl_
burled94825382burled
burler84723832burler
burley114715752burley
burls74228852burls
burly104922832burly
burse75527252burse
butle75023102butle
byre95023852byr_e
byrl95716012byrl_
byrled12437172byrled
byrls105711232byrls
carle74535702carle
circle1039702circle
cire65836382cir_e
dire56644152dir_e
dirge75117072dirge
dirl57430032dirl_
dirled84514902dirled
dirls64720502dirls
farle86929242farle
file75446652fi_le
fille84327402fille
fire76245602fir_e
girdle82110462girdle
girl56226562girl_
girlie73711462girlie
girls64518392girls
girly94415292girly
hire75538972hir_e
hiree85427802hiree
hirple11158972hirple
hirsle9159572hirsle
idle55423772_idle
ire36943182_ir_e
isle45121702_isle
kirtle10309472kirtle
lire47845302lir_e
lisle53916722lisle
merle75824372merle
mile66352582mi_le
mille75029132mille
mire66748242mir_e
orle45630462_orle
parle75836162parle
pile65649702pi_le
rifle85518332rifle
rile45650542ri_le
rille55728732rille
sidle65124042sidle
sire46150422sir_e
siree55238812siree
tile45451452ti_le
tire46143362tir_e
tirl45029932tirl_
tirled74714362tirled
tirls54519802tirls
title54721072title
vile76139812vi_le
virile9313432virile
virl76224482virl_
virls85618602virls
wile75944382wi_le
wire75839822wir_e

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538001461.65632487.9
3Display Results1461460.0334424.2
 (SQL Overall)1786911461.98590020.7
 
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.