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

193 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
foreign113683(None) 
coreign1037341coreign
coreigns1136322coreigns
feign94210712f__eign
forcing134013752forcing
fording123717042fording
forego1038902fore_go
foreigner1344662foreigner
foreman12312362foreman
foremen12412922foremen
foreran10311792foreran
forerun1037652forerun
forewing1539002forewing
forging124114722forging
forking154014842forking
forming133615732forming
reign65015192__reign
arraign845063arraign
boreen8314313bore_en
boring94724873bor_ing
borking144716173borking
codein94916723codei_n
codesign1274503codesign
coign85013913co__ign
condign1147733condign
consign1038773consign
cording113620823cording
coring94433963cor_ing
corking143018823corking
corning103720123corning
cortin82423153corti_n
cosign958783co_sign
deign74312803__deign
deraign936573deraign
dormin9312313dormi_n
dreigh11246443_dreigh
fadein1068843fadei_n
farcing133514003farcing
farding123716743farding
faring105231283far_ing
farming133515083farming
farting114120753farting
feeing104416503f_eeing
feigns10407753f__eigns
fermion1236763fermion
fireman1249333fireman
firemen1238773firemen
firepan1236983firepan
firing104021723fir_ing
firkin1337823firki_n
firming132811223firming
fleeing113511293fleeing
florigen12154633flor_igen
florin9312653flor_i_n
foaling113515843foaling
foaming133612993foaming
fobbing153410273fobbing
foehn11236323fo_e_hn
foeman11311233fo_eman
foemen11310523fo_emen
fogging133513733fogging
foiling113317653foiling
foin77231563fo__i_n
foining113013453foining
folding123912443folding
fonding123815423fonding
fooling113117373fooling
footing115017593footing
fopping153511133fopping
forage104617003for_age
foraging1358063foraging
foramen12310533foramen
foraying1537433foraying
forbid123312433forbi_d
forbids13268263forbids
fordid113512053fordi_d
fordoing1357303fordoing
fore78351473fore___
forearm1238703forearm
forebay1538133forebay
foreby1438633fore_by
forebye1536353forebye
foredid1238503foredid
foredo10510823fore_do
foredoing1456483foredoing
foredone1249733foredone
forefend1545603forefend
foregoing1455793foregoing
foregone1238583foregone
foregut1149163foregut
forehand1537693forehand
foreigners1444143foreigners
foreignism1652513foreignism
foreland1239013foreland
foreleg1137743foreleg
forelegs1236613forelegs
forelimb1544083forelimb
foremilk1744373foremilk
forenoon1146823forenoon
forepaw1595613forepaw
forerank1546753forerank
foreruns1146623foreruns
fores85847103fore__s
foresaw1377133foresaw
foresee10414333foresee
foreseen1139103foreseen
foreside12310303foreside
foresight1645323foresight
foreskin1547023foreskin
forest94926743fore_st
foresting13311363foresting
forests104114953forests
foretime1348213foretime
foretop12117893foretop
forever1338953forever
forewarn14117173forewarn
forewent1439423forewent
forewings1645113forewings
foreworn14108863foreworn
forfeit1339203forfei_t
forfeits1445803forfeits
forge95126943for__ge
forgings13287703forgings
forgive1436193forgive
forgiven1542983forgiven
forgo94418333for__go
forgoing1366853forgoing
forint9325023for_int
forkier144311593forkier
forlorn1096423forlorn
formic13310453formi_c
formica1436443formica
fornix1636033forni_x
forrit91916623forri_t
forties104323863forties
fortify1636523fortify
fortis95418613forti_s
forworn13107793forworn
fouling113315373fouling
fowling143713113fowling
foxing175012433fo_xing
freeing113713913freeing
freight1447603f_reight
frig85424503f_r_ig_
frigs96019273f_r_igs
frying134511403f_rying
furling114016563furling
furring114013143furring
gorging102611363gorging
goring84119573gor_ing
gorming112810833gorming
greige847203_greige
herein93717793herei_n
hoeing104117023ho_eing
hordein1138753hordei_n
hording123517053hording
horning113015003horning
horsing113215583horsing
lomein8410203lomei_n
lording93115233lording
moreen8313343more_en
morion86217733mor_ion
morning103215043morning
morrion959003morrion
murein8311763murei_n
olein5316003_olei_n
orbing93312363_orbing
orcein838183_orcei_n
orcin72716573_orci_n
oreide7311673_oreide
origan7310693_or_igan
origin7311033_or_igin
orpin73415533_orpi_n
pereion9312053pereion
poring94227273por_ing
porking143515813porking
porting103021783porting
portion9615493portion
reigns74811753__reigns
rein46040893__rei_n
resign74212583__resign
serein63318463serei_n
skreigh15243703skreigh
sorbing102815263sorbing
soring74731883sor_ing
sorning83116813sorning
sorting83221813sorting
sovereign1342253sovereign
toeing74418473to_eing
torsion7310803torsion
wording123014563wording
working153813253working
worming132811243worming

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 Limit1340271936.08022043.9
3Display Results1931930.0762539.5
 (SQL Overall)1786911936.56227231.2
 
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.