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 “koines” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
koines1041573(None) 
kines95039131k_ines
koine9516481koine_
alines65735222alines
amines84727982amines
azines155517072azines
bines76946792_bines
boings96416872boings
boinks125211272boinks
boites84322702boites
bones76446532bo_nes
bonnes85621452bonnes
bovines12412662bovines
brines85028852brines
chines115029172chines
cines75239682_cines
clines84926042clines
coignes103912152coignes
coined94523602coined
coiner84323782coiner
coiners93620752coiners
coins75834552coin_s
cones76457422co_nes
conies84338592conies
conines93827792conines
cosines94122672cosines
dines66449152_dines
doings84913182doings
domines102918972domines
dwines105013102dwines
eosines73718292eosines
exines135715802exines
fines86644262_fines
foined105915012foined
foins85523382foin_s
goings84911522goings
hoises94823672hoises
homines123518632homines
hones88144492ho_nes
imines84918352imines
iodines83616632iodines
joined144613072joined
joiner134114132joiner
joiners144211572joiners
joins125818412join_s
joints133811452joints
jones125028182jo_nes
kains96125642kain_s
kanes95529372k_anes
kaolines1239282kaolines
kernes104717522kernes
kibes115521112k_ibes
kikes85122552k_ikes
kinas95626912k_inas
kinds106221812k_inds
kine85643422k_ine_
kings105825562k_ings
kinks84926082k_inks
kinos96626142k_inos
kins85747902k_in_s
kites95432542k_ites
knifes136210212knifes
knives13458552knives
koans95818622koan_s
kois85129392koi__s
konks84917112ko_nks
kopjes1935362kopjes
krises105016082krises
lines57054572_lines
loins56728422loin_s
mines75651952_mines
moires8915632moires
monies83233162monies
nines55937342_nines
noises65021852noises
nones55639132no_nes
oinks94819912_oinks
ones46146532_o_nes
opines84820702opines
ovines94614342ovines
pines76048862_pines
poinds93511142poinds
pointes93216752pointes
points85618532points
poises84226542poises
pones74547042po_nes
ponies84833462ponies
seines65029902seines
shines95028912shines
sines55954822_sines
sones55444142so_nes
sozines16611262sozines
spines85132032spines
tines54848422_tines
toiles63923512toiles
tones56048662to_nes
tonnes65320852tonnes
toxines142912262toxines
trines64132562trines
twines94717272twines
urines64724122urines
vines85137642_vines
voices114414012voices
voiles94616442voiles
whines125120102whines
wines85546862_wines
zines145232652_zines
zones145528042zo_nes

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511082.67030918.0
3Display Results1081080.0333272.7
 (SQL Overall)1786911082.82963164.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.