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
biform136812(None) 
aciform1446012aciform
aliform1247032aliform
before11410152before
beworm1339992beworm
bicorn103610102bicorn
bifold1237222bifold
biformed1643692biformed
cubiform1744012cubiform
deform1259622deform
deiform1336692deiform
form95836872__form
inform11310152inform
misform1437512misform
oviform1544812oviform
reform11312712reform
triform1237852triform
tubiform1543732tubiform
uniform1247052uniform
aeriform1346093aeriform
affirm1435523affirm
afford1346493afford
afore85818603_afore
arciform1544793arciform
auriform1345183auriform
ausform1245233ausform
bacciform2052533bacciform
bagworm1566353bagworm
bailor83412603bailor_
bailors93212413bailors
barm86739603b__arm
befog1159013befo_g
befogs1246453befogs
befool1137713befool
befoul1137253befoul
berm86732753b__erm
besom95716973beso_m
bevor101510813bevor_
bevors111610343bevors
beworms1437933beworms
bicarb1238543bicarb
bicorne11297553bicorne
bicorns11338763bicorns
bicron103710773bicron
bider85728373bider_
biders94822803biders
bier65531833bi_er_
biers76225223bi_ers
biface1358103biface
biff125026893bif__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
bio57846083bi_o__
biofilm1444333biofilm
biog76122323bi_o_g
biogs85016113bi_ogs
bioherm1434653bioherm
biome94916993bi_ome
biont7727163bi_ont
bios66335323bi_o_s
biota74516823bi_ota
bipod104410823bipo_d
bipods11408593bipods
bird76128323bi__rd
birdfarm1642873birdfarm
birk106326863bi__rk
birl65830473bi__rl
biro66131213bi__ro
biros75325133biro_s
birr66022363bi__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
bursiform1642443bursiform
buxom1647153buxo_m
byword1535053byword
bywork1834863bywork
coliform1545563coliform
conform14310463conform
corm85735383__corm
cuniform1555023cuniform
defoam1238563defoam
deforms1337803deforms
deworm1249533deworm
disarm9310473disarm
dorm76834633__dorm
effort1238623effort
enorm74415643_enorm
ensiform1344353ensiform
farm95934533__farm
fifer115519973fifer_
fifers125414923fifers
filiform1644773filiform
fiord94313343fi_ord
firm96026453__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
fusiform1643983fusiform
gasiform1444303gasiform
gorm75529393__gorm
gruiform14103373gruiform
inarm7314423_inarm
infirm1137043infirm
informs1248073informs
isoform1244963isoform
ivory1137373_ivory
ixora1236913_ixora
janiform2044723janiform
libriform1642833libriform
lifer85822153lifer_
lifers95617843lifers
lyriform1643543lyriform
milord999573milord
minor74920063minor_
minors85117103minors
misforms1545893misforms
napiform1543763napiform
norm66429813__norm
omniform1544003omniform
oxford1763663oxford
pediform1645183pediform
perform1439283perform
piciform1764993piciform
piefort1249533piefort
piliform1555473piliform
pinworm1467183pinworm
piriform1555753piriform
pisiform1564963pisiform
preform1439613preform
pyriform1844403pyriform
ramiform1544703ramiform
reforms1239823reforms
reinform1346193reinform
reniform1346233reniform
retiform1345863retiform
rifer84721983rifer_
rigor62714053rigor_
rigors72813713rigors
rotiform1344663rotiform
setiform1345003setiform
simoom1037503simoom
slipform1543573slipform
storm76520403_storm
unciform1544653unciform
uniforms1355043uniforms
ursiform1343753ursiform
variform1645003variform
vasiform1644233vasiform
vigor92612423vigor_
vigors102911483vigors
visor82512833visor_
visors92912223visors
vizor173010093vizor_
vizors18328903vizors
worm96129493__worm

Search took 6 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 Limit1127162075.47020606.2
3Display Results2072070.0603450.0
 (SQL Overall)1786912075.93630102.9
 
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.