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

197 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
office143569(None) 
officer1534211officer
offices1536241offices
affiche1844312affiche
affine12310502affine
efface14366672efface
fice95737112__fice
offence1545352offence
officers1643802officers
offing13368642offing
offish15137272offish
offline1345782offline
offside1453692offside
orifice1246342orifice
orrice81410162orrice
suffice15197572suffice
advice12107883advice
affaire1344463affaire
affect1448903affect
affiance1645653affiance
affiches1945233affiches
affined1436413affined
affines1339483affines
affirm1435523affirm
affix1836003affi_x
affixed2134123affixed
affixer2033913affixer
affixes2035503affixes
afflict1547043afflict
afire86215913_afire
amice96122873_amice
bice86235563__bice
biface1358103biface
bodice11711423bodice
boffin14359053boffi_n
boffing16339983boffing
boffins15329073boffins
bonfire1287063bonfire
choice132010523choice
cilice103213353cilice
coffee144113743coff_ee
coffin14339813coffi_n
coffined1735993coffined
coffing163811253coffing
coffins153110193coffins
coffle14359043coff_le
confide13310203confide
confine12315583confine
coppice1537483coppice
cornice11612933cornice
deface123113863deface
defile105216663defile
define104718143define
deice84320033_deice
device124512163device
dice75841893__dice
doffing15357793doffing
dogface1454053dogface
dormice1237133dormice
edifice1344933edifice
effaced16225573effaced
effacer15255413effacer
effaces15277273effaces
effect1437443effect
effete1235183effete
effigy1642213effigy
effuse1234963effuse
enface112510353enface
entice81316863entice
face96140123__face
farce104925323_farce
fence105319913_fence
fices106031163__fices
fiche134616743__fiche
fico95824593__fico
fie67152443__fi_e
fife106027703__fife
file75446643__file
fine75147953__fine
fire76245593__fire
five107629743__five
flic96223733_flic_
flick145017213_flick
flics105418363_flics
flite85424963_flite
fogie96719003fogi_e
folic105319323folic_
fomite113314073fomite
force105324273_force
foxfire2042563foxfire
frise85322453_frise
fyce126316833__fyce
hospice14117063hospice
ice56737243___ice
iffier1236763iffier
juice14311323_juice
lice66045063__lice
maffick2143523maffick
mafic125615463mafic_
malice104818483malice
mice87442233__mice
mortice11711493mortice
nice65534713__nice
notice8313443notice
novice1138433novice
oafish121311723oafish
oblige937653oblige
odic74920573o_dic_
off96331633off___
offal1136243off_al
offals1235893offals
offcut1444703offcut
offed12359163off_ed
offences1645023offences
offend13365663offend
offense1343683offense
offer114311383off_er
offered1436143offered
offerer1335543offerer
offers12349963offers
officered1841913officered
official1644893official
officiate1744163officiate
offings14285833offings
offkey1932343offkey
offs107117013off__s
offset1238373offset
offsides1543393offsides
ogive9379093o_give
ohmic1237833ohmic_
oldie6415473oldi_e
olefine1038023olefine
oleic7313333oleic_
oleine6313793oleine
olive84817153o_live
once65423083o__nce
online6315843online
onside7511803onside
ontic74418573ontic_
oolite63319603oolite
oorie53026363oori_e
ophite11410563ophite
opine77422463o_pine
optic93715183optic_
optics102810183optics
optime1079353optime
oreide7311673oreide
orgic8311823orgic_
orifices1346483orifices
oroide7311703oroide
orpine83914483orpine
orrices9129363orrices
oscine8311563oscine
osmic939913osmic_
osmics1036463osmics
ossicle944483ossicle
otic66624823o_tic_
ounce77019933o_unce
ourie54027303ouri_e
outface123011973outface
outfire1049713outfire
outoffice1751403outoffice
ovine86316643o_vine
oxide131210953o_xide
oxime1498433o_xime
oxlike17307473oxlike
pice84641093__pice
plaice10311553plaice
police102918563police
price93725413_price
pumice1238223pumice
reface113616353reface
refile95122373refile
refine95225693refine
refire95419473refire
rice64942913__rice
roofie93411173roofi_e
saice75424053_saice
sice65545593__sice
slice74925823_slice
sluice849513sluice
soffit1237883soffi_t
soffits1335093soffits
softie93312483softi_e
spice95528813_spice
splice104915103splice
sufficed17205663sufficed
sufficer16225823sufficer
suffices16208183suffices
thrice114311573thrice
toffee123311013toff_ee
toffies133210213toffies
trice75127493_trice
twice104711123_twice
vice95732853__vice
voice104915323_voice
waffie15338563waffi_e

Search took 10 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 Limit1127161978.40613409.0
3Display Results1971970.470419.1
 (SQL Overall)1786911979.28219251.3
 
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.