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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
kamseen134401(None) 
kamseens1442821kamseens
khamseen1741811khamseen
kamsin1238322kams_in
khamseens1841192khamseens
almsmen1144583almsmen
ambeer104511603_ambeer
ameer75618983_am_eer
amen66733153_am__en
ashen87818673_a_shen
aspen75216093_a_spen
atween9166613_atween
axseed1456993_axseed
baleen8613053ba_leen
basemen1139083ba_semen
batsmen1146883batsmen
canteen9411083canteen
careen84119493ca_reen
casein83216453ca_sein
casern84713313ca_sern
cassene93111543cassene
damaskeen1651933damaskeen
dampen114310593dam_pen
damsel9148033dams_el
damsels10126713damsels
damson938063dams_on
dasheen1136393dasheen
daysmen1335083daysmen
fasten95114893fa_sten
gamesmen1345113gamesmen
gasmen93111563ga_smen
gombeen1243733gombeen
hamster12810423hamster
harshen1339283harshen
hasten95718563ha_sten
hausen9610383haus_en
hayseed1435633hayseed
kaiser103610373kais_er
kaiserin1245023kaiserin
kaisers11369273kaisers
kame105728233kam__e_
kames115024693kam__es
kamsins1346963kamsins
kasher134915033ka_sher
keen84830413k___een
khamsin1643983khams_in
kinsmen1335653kinsmen
lamster9109913lamster
lateen64014863la_teen
mammee94417853mammee_
mammees104411143mammees
nankeen1135043nankeen
oarsmen938093oarsmen
outseen72712333outseen
pampean1335543pampean
passee84522023passee_
ramee74633853ram_ee_
ramees84620893ram_ees
ramen75625193ram__en
ramson8310463rams_on
ratteen7329113ratteen
reseen64318413_reseen
samisen937673samisen
sarsen6314233sars_en
sateen63815013sa_teen
seen46943123___seen
tamein8313093tam_ein
unseen62012623_unseen
yamen104115183yam__en

Search took 8 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.403443402.0
2DLD Change Limit134027696.95619267.8
3Display Results69690.0135307.7
 (SQL Overall)178691697.37224239.1
 
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.