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

207 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
biform136813(None) 
aciform1446022aciform
aliform1247042aliform
before11410152before
beworm1339992beworm
bicorn103610102bicorn
bifold1237222bifold
biformed1643692biformed
cubiform1744022cubiform
deform1259632deform
deiform1336702deiform
form95836872__form
inform11310152inform
misform1437512misform
oviform1544822oviform
reform11312722reform
triform1237862triform
tubiform1543742tubiform
uniform1247062uniform
aeriform1346103aeriform
affirm1435523affirm
afford1346493afford
afore85818603_afore
arciform1544803arciform
auriform1345193auriform
ausform1245243ausform
bacciform2052543bacciform
bagworm1566353bagworm
bailor83412603bailor_
bailors93212413bailors
barm86739613b__arm
befog1159013befo_g
befogs1246453befogs
befool1137713befool
befoul1137253befoul
berm86732753b__erm
besom95716973beso_m
bevor101510813bevor_
bevors111610343bevors
beworms1437933beworms
bicarb1238543bicarb
bicorne11297553bicorne
bicorns11338763bicorns
bicron103710773bicron
bider85728383bider_
biders94822803biders
bier65531843bi_er_
biers76225223bi_ers
biface1358103biface
biff125026903bif__f
biffed15449883biffed
biffin14369103biffin
biffs134814413bif_fs
biffy164711133bif_fy
bifid11910703bif_id
biflex1834953biflex
bifocal1445373bifocal
biforate1346903biforate
biforked1842873biforked
bigfoot1355993bigfoot
bighorn1346063bighorn
bigos85020013bigo_s
bigot84828323bigo_t
bigotry1344523bigotry
bigots95015133bigots
bijou1458793bijo_u
bijous1548043bijous
bijoux2253453bijoux
biker116022563biker_
bikers124517553bikers
bimorph1643623bimorph
binary11312223binary
biner75930693biner_
biners85023633biners
binocs1039923binocs
bio57846093bi_o__
biofilm1444333biofilm
biog76122333bi_o_g
biogs85016113bi_ogs
bioherm1434653bioherm
biome94916993bi_ome
biont7727163bi_ont
bios66335333bi_o_s
biota74516823bi_ota
bipod104410823bipo_d
bipods11408593bipods
bird76128333bi__rd
birdfarm1642873birdfarm
birk106326873bi__rk
birl65830483bi__rl
biro66131223bi__ro
biros75325133biro_s
birr66022373bi__rr
birrs74917103bi_rrs
bison75716983biso_n
bisons83914373bisons
bistort91216523bistort
bistre83815023bistre
bistro8339943bistro
biter75030033biter_
biters83925243biters
bizone1738603bizone
bloom95918973b_loom
boom87435673b__oom
boor66130683b_oor_
boors74325013b_oors
bora66141633b__ora
bore66051333b__ore
bork106933823b__ork
born67338413b__orn
bort65960963b__ort
bosom95516923boso_m
broom95022213b_room
budworm1545273budworm
bursiform1642453bursiform
buxom1647153buxo_m
byword1535053byword
bywork1834863bywork
coliform1545573coliform
conform14310463conform
corm85735383__corm
cuniform1555033cuniform
defoam1238563defoam
deforms1337803deforms
deworm1249533deworm
disarm9310473disarm
dorm76834633__dorm
effort1238623effort
enorm74415643_enorm
ensiform1344363ensiform
farm95934543__farm
fifer115519973fifer_
fifers125414923fifers
filiform1644783filiform
fiord94313343fi_ord
firm96026463__firm
foam97127173__foam
for66952073__for_
fora75937393__fora
foram105124933__foram
forb97131333__forb
ford86835493__ford
fore78351473__fore
fork115930943__fork
forme105225993__forme
forms105327053__forms
fort76456443__fort
forum108318763__forum
from96923923__from
fusiform1643993fusiform
gasiform1444313gasiform
gorm75529393__gorm
gruiform14103383gruiform
inarm7314423_inarm
infirm1137043infirm
informs1248073informs
isoform1244963isoform
ivory1137373_ivory
ixora1236913_ixora
janiform2044733janiform
libriform1642843libriform
lifer85822153lifer_
lifers95617843lifers
lyriform1643553lyriform
milord999573milord
minor74920063minor_
minors85117103minors
misforms1545893misforms
napiform1543773napiform
norm66429813__norm
omniform1544013omniform
oxford1763663oxford
pediform1645193pediform
perform1439293perform
piciform1765003piciform
piefort1249543piefort
piliform1555483piliform
pinworm1467183pinworm
piriform1555763piriform
pisiform1564973pisiform
preform1439623preform
pyriform1844413pyriform
ramiform1544713ramiform
reforms1239823reforms
reinform1346203reinform
reniform1346243reniform
retiform1345873retiform
rifer84721983rifer_
rigor62714053rigor_
rigors72813713rigors
rotiform1344673rotiform
setiform1345013setiform
simoom1037503simoom
slipform1543583slipform
storm76520403_storm
unciform1544663unciform
uniforms1355043uniforms
ursiform1343763ursiform
variform1645013variform
vasiform1644243vasiform
vigor92612423vigor_
vigors102911483vigors
visor82512833visor_
visors92912223visors
vizor173010093vizor_
vizors18328903vizors
worm96129493__worm

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162076.08018538.8
3Display Results2072070.0603450.0
 (SQL Overall)1786912076.54627297.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.