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

217 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
offices153624(None) 
office1435691office_
officer1534211officer
officers1643801officers
affiches1945232affiches
affines1339482affines
affixes2035502affixes
effaces15277272effaces
fices106031162__fices
offences1645022offences
offings14285832offings
offsides1543392offsides
orifices1346482orifices
orrices9129362orrices
suffices16208182suffices
toffies133210212toffi_es
advices13136933advices
affaires1444303affaires
affects1535393affects
affiances1745153affiances
affiche1844313affiche
affine12310503affine_
affined1436413affined
affirms1534383affirms
affixed2134123affixed
affixer2033913affixer
affixers2143293affixers
afflicts1644003afflicts
amices105018013_amices
apices104916263_apices
baffies153612943baffi_es
bices95029963__bices
bifaces1448063bifaces
biffies152710853biffi_es
bodices12710593bodices
boffins15329073boffi_ns
bonfires1367383bonfires
calices114321693calices
carices114220953carices
choices142010613choices
cilices113814023cilices
cimices13279803cimices
codices12512583codices
coffees15329573coff_ees
coffined1735993coffined
coffins153110193coffi_ns
coffles152610003coff_les
confides14310573confides
confines13315653confines
coppices1638243coppices
cornices12713293cornices
cortices12615013cortices
culices113713123culices
cylices14359283cylices
defaces133213403defaces
defies104624053defi_es
defiles114016843defiles
defines114118683defines
deices94119373_deices
devices133212583devices
dices86434243__dices
dogfaces1554143dogfaces
edifices1454863edifices
efface14366673efface_
effaced16225573effaced
effacer15255413effacer
effacers16244233effacers
effects1535283effects
effigies1543513effigies
effuses1335903effuses
enfaces122110913enfaces
entices91616333entices
faces106439433__faces
facies113921593_facies
faeces114713123_faeces
falces115216003_falces
farces115223323_farces
fasces114914543_fasces
fauces114916153_fauces
feces105625363__feces
fences114617113_fences
fice95737113__fice_
fiches145219533__fiches
ficoes114613463__ficoes
ficus105015493__ficus
fifes114822393__fifes
files85441273__files
fines86644263__fines
fires85740753__fires
fives116027363__fives
fixes154723593__fixes
flicks154512993_flicks
flics105418363_flic_s
flies85630713_fli_es
flites95122443_flites
fogies104118063fogi_es
fomites123613203fomites
forces114422133_forces
fornices1369103fornices
foxfires2142813foxfires
fries85535603_fri_es
friges104116483_friges
frises94124273_frises
frites94922483_frites
frizes184015463_frizes
fyces139813643__fyces
hafizes2235983hafizes
helices12313723helices
hospices1587633hospices
ibices10398163_ibices
ices66129643___ices
iffier1236763iffi_er
iffiest1337963iffi_est
iffiness1435023iffiness
indices103513443indices
infixes17238133infixes
jiffies20327473jiffi_es
juices1549423_juices
latices9313763latices
mafficks2243173mafficks
malices114316623malices
mortices12711563mortices
murices112612283murices
notices9312283notices
novices1238223novices
obliges1037143obliges
offals1235893off_als
offcast1544473off_cast
offcut1444703off_cut
offcuts1542573offcuts
offed12359163off__ed
offence1545353offence_
offends14234293offends
offense1343683offense
offenses1443833offenses
offer114311383off__er
offered1436143offered
offerer1335543offerer
offerers1434933offerers
offers12349963off_ers
officered1841913officered
official1644893official
officials1743403officials
officiates1843693officiates
officious1763873officious
offing13368643offi_ng
offish15137273offi_sh
offkey1932343off_key
offline1345783offline_
offs107117013off___s
offset1238373off_set
offsets1333503offsets
offside1453693offside_
ofttimes1343123ofttimes
ogives10367913o_gives
oldies7314423oldi_es
olefines1137323olefines
oleines7313393oleines
olives94313953o_lives
oolites72817843oolites
ophites12310103ophites
opines84820703o_pines
optics102810183optic_s
optimes1148473optimes
ordines83014903ordines
oreides8312023oreides
orgies72316093orgi_es
orifice1246343orifice_
oroides8311973oroides
orpines94414793orpines
orrice81410163orrice_
orrises71312233orrises
oscines9310363oscines
osmics1036463osmic_s
ossicles1054183ossicles
ounces83617773o_unces
outfaces132311393outfaces
outfires1139863outfires
outoffices1851313outoffices
ovines94614343o_vines
oxides14109693o_xides
oximes15107423o_ximes
plaices11411143plaices
polices113118053polices
pollices12410753pollices
prices104524543_prices
pumices1338273pumices
radices102314263radices
refaces123216743refaces
refiles104122423refiles
refines105426343refines
refires104820313refires
refixes174813173refixes
rices75536153__rices
roofies103014413roofi_es
saices84221803_saices
sices75637273__sices
slices84022853_slices
sluices959073sluices
soffits1335093soffi_ts
softies103414613softi_es
spices104326033_spices
splices113914383splices
suffice15197573suffice_
sufficed17205663sufficed
sufficer16225823sufficer
sufficers17204533sufficers
suffixes21196353suffixes
taffies133012693taffi_es
toffees13327083toff_ees
trices84826333_trices
unfixes17238113unfixes
varices123313573varices
vices105725533__vices
voices114414013_voices
vortices1369123vortices
waffies163611443waffi_es

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 Limit1340272175.68623571.4
3Display Results2172170.0802712.5
 (SQL Overall)1786912176.17228951.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.