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

64 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
flatmate134639(None) 
flatmates1446191flatmates
flatware1444882flatware
playmate1566462playmate
seatmate1048572seatmate
classmate1344863classmate
clathrate1445343clathrate
clavate1238713cla_vate
climate11312833cl_imate
dilatate947773dilat_ate
falcate12311613f_alcate
fermate122813003f_ermate
filtrate1148223filtrate
flagman13186173flagma_n
flambe13489153fla_m_be
flambee144210013fla_mbee
flame105124443fla_m__e
flammable1844173flammable
flatboat1346473flatboat_
flatboats1444483flatboats
flatcap1463653flatca_p
flatcaps1563403flatcaps
flatcar1274613flatca_r
flatcars1344623flatcars
flatfeet1446213flatfeet
flatland1264963flatland
flatlet10312253flatlet_
flatlets1147373flatlets
flatline11298923flatline
flatted114012943flat__ted
flatten10429653flat__ten
flatter103815963flat__ter
flatwares1544763flatwares
flatwash1742423flatwash
flatways1744323flatways
flatwise1443973flatwise
floatage1244403float_age
flotage1136673flot_age
fluctuate1443113fluctuate
fluxgate1942893fluxgate
formate123115093f_ormate
glabrate1146033glabrate
glaciate1168073glaciate
gladiate1057053gladiate
glutamate1242543glutamate
hamate113319823_ha_mate
imamate1138093ima_mate
labiate91313573_labiate
lactate9312693_lactate
lanate6421263_la_nate
latte55426303_lat__te
mammate104411273_mammate
palmate113215233_palmate
placate11312433pla_cate
planate9314573pla_nate
platane93112303plat_ane
playdate1465263playdate
playmates1646603playmates
plumate1149803pl_umate
ramate83921683_ra_mate
satiate7315403_satiate
seatmates1157813seatmates
teammate1245613teammate
ultimate1049203ultimate

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit146162648.39317414.8
3Display Results64640.0302133.3
 (SQL Overall)178691648.57920828.9
 
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.